ID: 21928
Updated by: [EMAIL PROTECTED]
Reported By: [EMAIL PROTECTED]
-Status: Open
+Status: Feedback
Bug Type: ODBC related
Operating System: Win2k server
PHP Version: 4.3.0
New Comment:
kept as feedback until testing done...
Previous Comments:
------------------------------------------------------------------------
[2003-01-29 00:29:25] [EMAIL PROTECTED]
BTW: I am running MDAC 2.7 SP1
------------------------------------------------------------------------
[2003-01-29 00:27:09] [EMAIL PROTECTED]
I'll run your test in the morning. It might be notable that I can run
my script from the command line and have no problems connecting to the
ODBC DSN. But when I run it through IIS, it fails. I ran this same
script on my local win2k pro desktop and it works fine. This is only
happening on my win2k server. I searched the net and see lots of
people with this same issue, but cannot find a single one that has a
resolution.
------------------------------------------------------------------------
[2003-01-28 22:40:06] [EMAIL PROTECTED]
I don't believe this is a PHP bug itself at all. First off what
version of the MDAC are you using?
Second can you try doing the following:
$dbh = odbc_connect(); // yes I know it will fail
$res = odbc_data_source($dbh, SQL_FETCH_FIRST);
And print out the results of the $res, and call the data_source() a few
more times with SQL_FETCH_NEXT instead of SQL_FETCH_FIRST?
Thanks
------------------------------------------------------------------------
[2003-01-28 18:47:07] [EMAIL PROTECTED]
This is a system DSN.
Here is the output from the lines you sent me.
Content-type: text/html
X-Powered-By: PHP/4.3.0
resource(1) of type (odbc link)
------------------------------------------------------------------------
[2003-01-28 18:17:10] [EMAIL PROTECTED]
Is "ti_readonly" a userDSN or a systemDSN?
Run this EXACT script from the COMMAND LINE on your server and report
the output:
<?php
var_dump(odbc_connect("ti_readonly","TI_readonly","TI_readonly"));
?>
------------------------------------------------------------------------
The remainder of the comments for this report are too long. To view
the rest of the comments, please view the bug report online at
http://bugs.php.net/21928
--
Edit this bug report at http://bugs.php.net/?id=21928&edit=1
