how to access server mdb files using odbc driver with php

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
mthalavaimca
Forum Newbie
Posts: 2
Joined: Wed Feb 10, 2010 3:10 am

how to access server mdb files using odbc driver with php

Post 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
JakeJ
Forum Regular
Posts: 675
Joined: Thu Dec 10, 2009 6:27 pm

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

Post by JakeJ »

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

Post 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.
Post Reply