ID: 25958
User updated by: brian dot garvis at mascommsys dot com
Reported By: brian dot garvis at mascommsys dot com
-Status: Bogus
+Status: Open
Bug Type: ODBC related
Operating System: Windows 2003 Server
PHP Version: 4.3.2
New Comment:
I have had 5 others try and make this work now. No one can get php to
work with a DSN when the drive is mapped. I have searched everything
online that I could find and it seems that no one has been successful.
I guess that everyone out there is configuring theirs wrong as well.
Please show me one example or person that has gotten this to work?
Previous Comments:
------------------------------------------------------------------------
[2003-11-01 10:37:04] [EMAIL PROTECTED]
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.
------------------------------------------------------------------------
[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
------------------------------------------------------------------------
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
