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
Welcome back! If you're the original bug submitter, here's where you can edit the bug or add additional notes.
If you forgot your password, you can retrieve your password here.
Password:
Status:
Package:
Bug Type:
Summary:
From: stimocea at uttgm dot ro
New email:
PHP Version: OS:

 

 [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: Wed Dec 25 06:01:29 2024 UTC