CODEWITHSUNDEEP
phpdatabasems-accessodbc
Chris
Chris

Reputation: 1278

Unable to connect to MS Access database located in a network using php

I am developing a web application that should be connected to Access database. I am working using php. If my database is local, I don't have any problem. Originally the database is located in a network. When I test my webpage connecting to the network database, I get this error

Warning: odbc_exec() [<a href='function.odbc-exec'>function.odbc-exec</a>]: SQL error: [Microsoft][ODBC Microsoft Access Driver]  'T:\Chris\Test1.mdb' not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides., SQL state S1009 in SQLExecDirect

I know that this question has been asked by many people but I am not yet able to solve my problem. Does anyone has any idea where the problem occurred?

Thank you in advance!

Upvotes: 0

Views: 3260

Answers (1)

Chris
Chris

Reputation: 1278

My problem was solved by users comments. The solution is don't use network derive name like T:. Use the network path, like \\IP address\db_folder\db_name.mdb. This first needs sharing the folder on the network.

Upvotes: 1

Related Questions