If you attempt to echo out a Resource Id it tells you it's name :) This should still work in an exec.
Best regards, Andrew Hill Director of Technology Evangelism OpenLink Software http://www.openlinksw.com Universal Data Access & Data Integration Technology Providers > -----Original Message----- > From: LeTortorec, Jean-Louis [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, October 02, 2001 2:10 PM > To: '[EMAIL PROTECTED]' > Subject: [PHP-DB] connecting SQL 7.0 > > > $a=odbc_connect("mydsn","myid","mypwd") or die("Database is down"); > echo "$a"; > > > When I execute this script, I got $a being "Resource id #1". > but $a should be an integer in order to do a query like > $b=odbc_exec($a,"select * from mytable"); > > > the dsn I created is a system DSN, as suggested my a member of the mailing > list. > I run PHP4.0 and Apache 1.3 under W2000. > > Any suggestion? > > Thanks. > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]