Hi,
Unfortunately I do not know how to solve your problem.
I have a problem about connecting to an Access database on NT with php 4 and I
wonder if you can help me. Here is my problem:
I would like to ask if you know a way to send queries to an MS Access
database without to have to add the database in the system DNS under
ODBC configuration. I would like to know if there are functions (like in
ASP) where you can pass the path to the database instead of the name of
the data source. (something like
conect_db('c:\db\mydb.mbd','user','passwd');
I know how to access the db if it is on the same computer as the server and if
it is added under the system dns in odbc.
Thank you,
Catalin
Daniel Furse wrote:
> Hi everyone,
>
> I'm trying to connect an Access database that is not on the same server as
> the web server. All the servers are Windows NT 4, the web server is IIS4,
> and I'm using PHP4. Whenever I try to query the database, it returns:
>
> Warning: SQL error: [Microsoft][ODBC Microsoft Access 97 Driver] The
> Microsoft Jet database engine cannot open the file 'SIDSC.MDB'. It is
> already opened exclusively by another user, or you need permission to view
> its data., SQL state S1000 inSQLExecDirect
>
> I've checked that the database is not opened by anyone else. I've also tried
> creating a new database on the web server and creating links to the tables
> in Access, but I still get the same error. The remote database has read
> permissions for the 'Everyone' group, so does the entire directory path, and
> the share.
>
> Can anyone help?
>
> Many thanks,
>
> Dan
>
> --
> PHP Windows Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
