Bug #15758 Updated: PHP odbc_connect() doesn't work on IIS 5.0

ID: 15758 Updated by: kalowsky@php.net Reported By: stimocea@uttgm.ro -Status: Open +Status: Closed Bug Type: ODBC related Operating System: Windows 2000 Advanced Server PHP Version: 4.1.1 New Comment: This bug has been fixed in CVS. Previous Comments: ------------------------------------------------------------------------ [2002-02-27 05:11:02] stimocea@uttgm.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 ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=15758&edit=1