#32991 [NEW]: Error connecting to Access Database using ODBC

From: info at genitek dot net Operating system: Win 2K Pro PHP version: 4.3.10 PHP Bug Type: ODBC related Bug description: Error connecting to Access Database using ODBC Description: ------------ php.ini-dist with register global ON MDAC 2.8 Apache 1.3.33 PHP 4.3.10 Reproduce code: --------------- $conn=odbc_connect("SYSTEM_DNS", "", ""); if (!$conn) { Error_handler( "Error in odbc_connect" , $conn ); } $query="Select * from QUERY"; $result = odbc_exec($conn,$query); if (!$result) { exit("Error in SQL"); } Expected result: ---------------- Return no error ! Actual result: -------------- Return, ODBC error, I receive in the ODBC trace log this : httpd 368-3ac EXIT SQLConnectW with return code -1 (SQL_ERROR) HDBC 00A412F8 WCHAR * 0x00A42500 [ -3] "SYSTEM_DNS\ 0" SWORD -3 WCHAR * 0x1F7C4AA0 [ -3] "******\ 0" SWORD -3 WCHAR * 0x1F7C4AA0 [ -3] "******\ 0" SWORD -3 DIAG [S1000] [Microsoft][Pilote ODBC Microsoft Access] Impossible d'ouvrir la base de données '(Inconnu)'. Ce n'est peut-être pas une base de données que votre application reconnaît, ou le fichier est peut-être endommagé. (-1028) And the only thing I have to do to correct the problem, RESTART APACHE.... than return or refresh the web site.. and everithing is OK for a moment... how long, I can figure... -- Edit bug report at http://bugs.php.net/?id=32991&edit=1 -- Try a CVS snapshot (php4): http://bugs.php.net/fix.php?id=32991&r=trysnapshot4 Try a CVS snapshot (php5.0): http://bugs.php.net/fix.php?id=32991&r=trysnapshot50 Try a CVS snapshot (php5.1): http://bugs.php.net/fix.php?id=32991&r=trysnapshot51 Fixed in CVS: http://bugs.php.net/fix.php?id=32991&r=fixedcvs Fixed in release: http://bugs.php.net/fix.php?id=32991&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=32991&r=needtrace Need Reproduce Script: http://bugs.php.net/fix.php?id=32991&r=needscript Try newer version: http://bugs.php.net/fix.php?id=32991&r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=32991&r=support Expected behavior: http://bugs.php.net/fix.php?id=32991&r=notwrong Not enough info: http://bugs.php.net/fix.php?id=32991&r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=32991&r=submittedtwice register_globals: http://bugs.php.net/fix.php?id=32991&r=globals PHP 3 support discontinued: http://bugs.php.net/fix.php?id=32991&r=php3 Daylight Savings: http://bugs.php.net/fix.php?id=32991&r=dst IIS Stability: http://bugs.php.net/fix.php?id=32991&r=isapi Install GNU Sed: http://bugs.php.net/fix.php?id=32991&r=gnused Floating point limitations: http://bugs.php.net/fix.php?id=32991&r=float No Zend Extensions: http://bugs.php.net/fix.php?id=32991&r=nozend MySQL Configuration Error: http://bugs.php.net/fix.php?id=32991&r=mysqlcfg