RE: [PHP-DB] connecting SQL 7.0

Does this DSN test successfully in the ODBC Administrator? If so, try an odbc trace - see what's going on. 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:32 PM > To: 'php-db@lists.php.net' > Subject: 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. > > > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net > For additional commands, e-mail: php-db-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net > >