RE: [PHP-DB] connecting SQL 7.0

Here is the full script: $a=odbc_connect("mydsn","myid","mypwd") or die("Database is down"); echo "$a"; $b=odbc_exec($a,"select * from mytable"); echo odbc_error (); FYI, if I execute only the first 2 lines, there is no problem, meaning that the server is accesssible ($a is "Resource id #1"). When the whole script is executed with Internet Explorer, a windows pops up and says: "The connection with the server was reset". When executed with Opera, the window says: "Repeated attemps failed to load this page completely. Them may be a problem on the server". the echo odbc_error() does not help. The Apache server, and php pages are on my PC (localhost) connected to a LAN, and the SQL Server is on a NT server on the LAN. The dsn odbc driver is on my PC. What's wrong here and what should I change? Thanks to all for your inputs. -----Original Message----- From: Andrew Hill [mailto:ahill@openlinksw.com] Sent: Tuesday, October 02, 2001 2:05 PM To: LeTortorec, Jean-Louis; php-db@lists.php.net Subject: RE: [PHP-DB] connecting SQL 7.0 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:JLeTortorec@healthcore.com] > Sent: Tuesday, October 02, 2001 2:10 PM > To: 'php-db@lists.php.net' > 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. > >