ID: 25958
Updated by: [EMAIL PROTECTED]
Reported By: brian dot garvis at mascommsys dot com
-Status: Open
+Status: Bogus
Bug Type: ODBC related
Operating System: Windows 2003 Server
PHP Version: 4.3.2
New Comment:
If the SQL.log is blank, it is not finding the driver
requested. That would indicate an ODBC configuration
error on the local machine, not a PHP error. That
explination fits with your initial error.
Previous Comments:
------------------------------------------------------------------------
[2003-10-31 17:40:36] brian dot garvis at mascommsys dot com
I can give you the trace, but it is a zero byte file. ODBC does not
see any errors. The trace only produces a file on error.
------------------------------------------------------------------------
[2003-10-31 09:38:38] [EMAIL PROTECTED]
If you cannot give me a trace of the SQL connection, I
cannot help you.
------------------------------------------------------------------------
[2003-10-30 18:49:38] brian dot garvis at mascommsys dot com
After working on this for the past week with anyone and everyone we
could find to help out, we are still where we started.
We have verified that MS ODBC works fine to database on local machine.
We have tried to connect to different databases on different remote
machines using both php and MS Query. MS Query has no problem
accessing remote DBase & Access databases using the same DSN's that PHP
is using. PHP to the same remote databases always returns the same
errors with a "null" "Resource ID #".
------------------------------------------------------------------------
[2003-10-23 14:34:06] brian dot garvis at mascommsys dot com
Turning on Machine-Wide tracing using odbctrac.dll in ODBC Data Source
Administrator and reproducing the problem does not create any entries
in the SQL.LOG. I did make the user "Administrator" invalid for the
shared drive and the SQL.LOG file filled quickly with errors. Errors
stopped when I added the "Administrator" user back on the shared
drive.
>From my ODBC Data Source Administrator, System DSN, System Data
Sources:
Name: DEMOSASI
Driver: Microsoft dBase Driver (*.dbf)
>From the ODBC dBASE Setup for DSN DEMOSASI:
Data Source Name: DEMOSASI
Database VErsion: dBase 5.0
Directory: Z:\ (mapped shared folder where DB resides on another
machine)
Driver:
Collating Sequence: ASCII
Page Timeout: 5
------------------------------------------------------------------------
[2003-10-22 19:42:18] [EMAIL PROTECTED]
Please include your DSN entry, and a SQL Log for the connection attempt
if you can. From the sounds of it, you're not configured properly on
the ODBC Administrator end, and thus not a PHP bug.
------------------------------------------------------------------------
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/25958
--
Edit this bug report at http://bugs.php.net/?id=25958&edit=1
