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
View Developer Edit
Welcome! If you don't have a Git account, you can't do anything here.
If you reported this bug, you can edit this bug over here.
(description)
Block user comment
Status: Assign to:
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 05:01:27 2024 UTC