ID: 21928
User updated by: [EMAIL PROTECTED]
Reported By: [EMAIL PROTECTED]
-Status: Feedback
+Status: Open
Bug Type: ODBC related
Operating System: Win2k server
PHP Version: 4.3.0
New Comment:
This is what I ran from IIS
<?
$dbh = odbc_connect(); // yes I know it will fail
$res = odbc_data_source($dbh, SQL_FETCH_FIRST);
echo $res;
$res = odbc_data_source($dbh, SQL_FETCH_NEXT);
echo $res;
?>
These are the results.
Warning: Wrong parameter count for odbc_connect() in
c:\inetpub\wwwroot\survey\test.php on line 3
Warning: odbc_data_source(): supplied argument is not a valid ODBC-Link
resource in c:\inetpub\wwwroot\survey\test.php on line 4
Warning: odbc_data_source(): supplied argument is not a valid ODBC-Link
resource in c:\inetpub\wwwroot\survey\test.php on line 6
Previous Comments:
------------------------------------------------------------------------
[2003-01-29 07:19:09] [EMAIL PROTECTED]
kept as feedback until testing done...
------------------------------------------------------------------------
[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)
------------------------------------------------------------------------
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
