From: [EMAIL PROTECTED]
Operating system: Windows 2000 Advanced Server
PHP version: 4.1.1
PHP Bug Type: ODBC related
Bug description: PHP odbc_connect() doesn't work on IIS 5.0
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 bug report at http://bugs.php.net/?id=15758&edit=1
--
Fixed in CVS: http://bugs.php.net/fix.php?id=15758&r=fixedcvs
Fixed in release: http://bugs.php.net/fix.php?id=15758&r=alreadyfixed
Need backtrace: http://bugs.php.net/fix.php?id=15758&r=needtrace
Try newer version: http://bugs.php.net/fix.php?id=15758&r=oldversion
Not developer issue: http://bugs.php.net/fix.php?id=15758&r=support
Expected behavior: http://bugs.php.net/fix.php?id=15758&r=notwrong
Not enough info: http://bugs.php.net/fix.php?id=15758&r=notenoughinfo
Submitted twice: http://bugs.php.net/fix.php?id=15758&r=submittedtwice
