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:[EMAIL PROTECTED]] 
Sent: Tuesday, October 02, 2001 2:05 PM
To: LeTortorec, Jean-Louis; [EMAIL PROTECTED]
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
Universal Data Access & Data Integration Technology Providers

> -----Original Message-----
> From: LeTortorec, Jean-Louis [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, October 02, 2001 2:10 PM
> 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 (
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to