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:
Not a PHP bug, please leave marked as bogus. From the Microsoft documentation area: "STATUS This behavior is by design. " .... " For example, if the client machine has a mapped drive to the database (M:\DataFolder\Database.mdb), it works fine at design-time. However, when viewed in the browser, the Web server processes the code based on the information given. The Web server checks its M: drive, which more than likely does not have a valid path to the database. " Previous Comments: ------------------------------------------------------------------------ [2003-11-02 07:42:40] brian dot garvis at mascommsys dot com 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? ------------------------------------------------------------------------ [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 #". ------------------------------------------------------------------------ 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