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 Add Comment Developer Edit
Anyone can comment on a bug. Have a simpler test case? Does it work for you on a different platform? Let us know!
Just going to say 'Me too!'? Don't clutter the database with that please !
Your email address:
MUST BE VALID
Solve the problem:
24 - 12 = ?
Subscribe to this entry?

 
 [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

Add a Patch

Pull Requests

Add a Pull Request

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 Apr 20 03:01:28 2024 UTC