#32991 [Opn]: Error connecting to Access Database using ODBC
| From: | info at genitek dot net | Date: | Mon, 09 May 2005 19:02:02 +0000 |
| Subject: | #32991 [Opn]: Error connecting to Access Database using ODBC | ||
| References: | 1 | Groups: | php.bugs |
| Request: | Send a blank email to php-bugs+get-78820@lists.php.net to get a copy of this message | ||
ID: 32991
User updated by: info at genitek dot net
Reported By: info at genitek dot net
Status: Open
Bug Type: ODBC related
Operating System: Win 2K Pro
PHP Version: 4.3.10
New Comment:
The error only arrive sometime, but when arrive, always stay until I
restart apache. After the restart, the error disapear for a moment
then, comme back
Previous Comments:
------------------------------------------------------------------------
[2005-05-09 21:00:22] info at genitek dot net
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 this bug report at http://bugs.php.net/?id=32991&edit=1