|  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #15758 PHP odbc_connect() doesn't work on IIS 5.0
Submitted: 2002-02-27 05:11 UTC Modified: 2002-04-26 10:57 UTC
Avg. Score:4.0 ± 1.0
Reproduced:1 of 2 (50.0%)
Same Version:1 (100.0%)
Same OS:0 (0.0%)
From: stimocea at uttgm dot ro Assigned:
Status: Closed Package: ODBC related
PHP Version: 4.1.1 OS: Windows 2000 Advanced Server
Private report: No CVE-ID: None
 [2002-02-27 05:11 UTC] stimocea at uttgm dot ro
ODBC System DSN:
DBTest - points to DBTest.mdb (Access 2000) using Microsoft Access driver (*.mdb) for Access 2000. No username, no password, no "exclusive" access checked!

TestFile.php content
    $conn = odbc_connect("DBTest", "", "") or die("Connecting error!");
    $rsRecords = odbc_exec($conn, "SELECT * FROM Table1") or die("Query error!");

    while (odbc_fetch_into($rsRecords, &$row)){
        echo $row[0]." ".$row[1]."<BR>";
Result (running IIS 5.0):
"Warning: SQL error: [Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot open the file '(unknown)'. It is already opened exclusively by another user, or you need permission to view its data., SQL
state S1000 in SQLConnect in C:\inetpub\wwwroot\directory\Test.php on line 3
Connecting error!"

I stopped IIS and started Apache (on the same server and port). Then the connection was established perfectly fine and the result was the content of Table1:
1 Text1
2 Text2
3 Text3
4 Text4


Add a Patch

Pull Requests

Add a Pull Request


AllCommentsChangesGit/SVN commitsRelated reports
 [2002-04-26 10:57 UTC]
This bug has been fixed in CVS.

PHP Copyright © 2001-2023 The PHP Group
All rights reserved.
Last updated: Wed Mar 29 10:03:53 2023 UTC