Page 1 of 1

how to access server mdb files using odbc driver with php

Posted: Wed Feb 10, 2010 3:28 am
by mthalavaimca
I develop php site in localhost using through XAMPP control panel. I need access mdb file from my lan (another)system using odbc(DSN) driver.but it will cause the following error

Warning: odbc_connect() [function.odbc-connect]: 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:\Program Files\xampp\htdocs\supreme\excl_det.php on line 8

8 $conn=odbc_connect("netsamp","" ,"");

How can i rectify this above error?

Thanks,
M.Thalavai

Re: how to access server mdb files using odbc driver with php

Posted: Wed Feb 10, 2010 10:49 am
by JakeJ
Did you set up DSN?

Re: how to access server mdb files using odbc driver with php

Posted: Mon Feb 15, 2010 11:19 pm
by mthalavaimca
s i did setup system dsn for the name of netsamp with using network map drive and assign the network path mdb file.