Posted by chadlupkes on 11/23/05 17:05

Here's the latest update:

<?php
$connectionstring = odbc_connect("DFWDB", "chad", "dfw");
if (odbc_error())
{
echo odbc_errormsg($connectionstring);
}
odbc_close($connectionstring);
?>

This is what comes out:

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\politics\DFW\connecttodb.php on line 2

Warning: odbc_errormsg(): supplied argument is not a valid ODBC-Link
resource in C:\Inetpub\wwwroot\politics\DFW\connecttodb.php on line 5

Warning: odbc_close(): supplied argument is not a valid ODBC-Link
resource in C:\Inetpub\wwwroot\politics\DFW\connecttodb.php on line 7

--
This doesn't make sense. I don't have any other connections open to
the database, although I can't get the ODBC logfile to work to check.
I haven't set any restrictions on access, since this is all on my local
machine, although I'm not sure what permissions I need to set. And the
odbc_ functions just seem to fail.

I'm really lost.

• Next in forum: Re: Ereg
• Prev in forum: Re: Using PHP to pull from MS Access DB
• Thread view: Re: Using PHP to pull from MS Access DB

[Reply to this message]