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
how to access server mdb files using odbc driver with php
Moderator: General Moderators
-
mthalavaimca
- Forum Newbie
- Posts: 2
- Joined: Wed Feb 10, 2010 3:10 am
Re: how to access server mdb files using odbc driver with php
Did you set up DSN?
-
mthalavaimca
- Forum Newbie
- Posts: 2
- Joined: Wed Feb 10, 2010 3:10 am
Re: how to access server mdb files using odbc driver with php
s i did setup system dsn for the name of netsamp with using network map drive and assign the network path mdb file.