php.net |  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
Votes:2
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
<?php
    $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

Patches

Pull Requests

History

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


 
PHP Copyright © 2001-2024 The PHP Group
All rights reserved.
Last updated: Sat Dec 21 17:01:58 2024 UTC