ODBC error
| From: | galfano carboni | Date: | Thu, 19 Jul 2001 12:01:06 +0000 |
| Subject: | ODBC error | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-10570@lists.php.net to get a copy of this message | ||
hi everybody,
when i call to my file (my_file.php), the next error occurs:
[the scenario]
Winnt 4.0 SP6
IIS 4
php 4.0.5
[my_file.php]
<?php
$con = odbc_connect('the_dsn', '', '');
odbc_close($con);
?>
[the error: i translated it from the spanish (or at least i tried to...)]
Warning: SQL error. [Microsoft] [Microsoft Access ODBC Driver] The Microsoft Jet data base
engine can't open the file '(unknown)'. It's opened in exclusive mode for other
user or you need privileges to read it., SQL state $1000 in SQLConnect in C:\the_path\my_file.php on
line 5.
however, nobody has opened the data base and i actually have all the privileges too. I've put
the file and the data base into another different computer (with the same operative system and
configuration) and everything works perfectly.
Tip: With a similar asp file i have no problem:
[my_file.asp]
<%
set con=server.createobject("ADODB.Connection")
con.open "dsn=the_dsn"
con.close
%>
any advise?
thanks in advance,
galfano carboni.
Get 250 color business cards for FREE!
http://businesscards.lycos.com/vp/fastpath/