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 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]
