Cannot connect to access db

[NYJimbo]

I've moved a bunch of accounts from an old HELM server to a new PLESK 10.4.4 Update #47 system. I am now trying to get Access Databases work. I was able to make the ODBC connector but now when I try to specifiy the file path it fails no matter what I do.

In the "Set Up an ODBC Connection" I put in the location of the file name and then hit next and it comes up with this:

Error: Unable to connect to the data source using the defined settings. Server has returned the following error:
ODBCError HY000: [Microsoft][ODBC Microsoft Access Driver] Could not find file '(unknown)'.

I tried putting the file in different locations and tried different pathing conventions but it results in the same error each time. For example I made a folder under called "db" as in "/httpdocs/my domain.com/db" (using the correct domain of course) and then put that path in the "[DBQ] Database file path" but it fails. I am not sure if this is relative or absolute pathing or if I am missing anything. I tried it with the file name "local.mdb" and without it.

I tried many different combo's so I am not sure if its me or if this is a bug.

Can someone give me an example of where to put the file and what the exact "location" string should be so I can tell if this is really something I am doing wrong and not a bug ?

 

[IgorG]

You can try to trace filesystem access with filemon utility and find request to missing database file.

 

[NYJimbo]

But that doesnt answer my question. I needed to know what would be a correct example of what path to put into that field.

 

[DGrover]

Have you found your solution yet? I am in a similar situation, but have been able to get the ODBC connection to work. Here is what I did to set up the ODBC connection.

1. In File Manager, navigate to the directory one level up from the directory that contains your database file
2. Click the "change access rights..." padlock icon to the right of the db file's directory name
3. You will be in the "Setup Access Permissions" section
4. There will be two checkboxes and right below those, in bold, is the physical path to this directory
5. Highlight and copy this directory/file path
6. Go to the "Set up an ODBC Connection" page
7. In the Database File Path box, paste your directory/file path
8. Make sure you have any account name or passwords associated with your database also entered
9. Click test connection and it should (key word here - should) work

Regarding your question about where to located the directory/file, my database file is in a directory located a few levels under httpdocs, but as long as it is at least contained in httpdocs, I don't think it matters where.