Skip to Content
0
Former Member
Apr 21, 2014 at 05:37 PM

MS ACCESS data store connectivity issues.

311 Views

Hello All,

When I try to create a data store for MS ACCESS database, I am able to view the data and the data store is also connecting with no issues. But when I try to run the job I am getting the following errors.

My *.mdb file is located in a remote location(shared path) though I have already created a System DSN, still I'm getting issues.

ODBC call <SQLDriverConnect> for data source <EDIData> failed: <[Microsoft][ODBC Microsoft Access Driver] '(unknown)' is 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

ODBC call <SQLDriverConnect> for data source <TEST> failed: <[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified>. Notify Customer Support.


Thanks,

Sairam Jalluru.