#32991 [Opn->Bgs]: Error connecting to Access Database using ODBC
| From: | sniper@php.net | Date: | Mon, 09 May 2005 22:46:46 +0000 |
| Subject: | #32991 [Opn->Bgs]: Error connecting to Access Database using ODBC | ||
| References: | 1 | Groups: | php.bugs |
| Request: | Send a blank email to php-bugs+get-78827@lists.php.net to get a copy of this message | ||
ID: 32991
Updated by: sniper@php.net
Reported By: info at genitek dot net
-Status: Open
+Status: Bogus
Bug Type: ODBC related
Operating System: Win 2K Pro
PHP Version: 4.3.10
New Comment:
Sorry, but your problem does not imply a bug in PHP itself. For a
list of more appropriate places to ask for help using PHP, please
visit http://www.php.net/support.php as this bug system
is not the
appropriate forum for asking support questions. Due to the volume
of reports we can not explain in detail here why your report is not
a bug. The support channels will be able to provide an explanation
for you.
Thank you for your interest in PHP.
Previous Comments:
------------------------------------------------------------------------
[2005-05-09 21:02:01] info at genitek dot net
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
------------------------------------------------------------------------
[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