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:[EMAIL PROTECTED]]
> Sent: Tuesday, October 02, 2001 2:32 PM
> To: '[EMAIL PROTECTED]'
> 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:[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]
>
>


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

Reply via email to