how to access server mdb files using odbc driver with php
Posted: Wed Feb 10, 2010 3:28 am
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
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