Symptom
- MS Access database is accessible through ODBC drivers on Windows and Unix, is it also a valid data source for Data Services to read (or write) data?
- Error: ODBC call <SQLDriverConnect> for data source <Bid Stats Combined Sources> failed: <[Microsoft][ODBC Microsoft Access Driver] The Microsoft Access database engine cannot open or write to the
file '(unknown)'. - "ODBC call <SQLDriverConnect> to connect database <dbname> failed with error: <ODBC call <SQLDriverConnect> for data source <dbname> 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 resides.>. Notify Customer Support.>."
- ODBC call <SQLDriverConnect> for data source <MS Access Database> failed: <[Microsoft][ODBC Driver Manager]Data source name not found and no default driver specified>. Notify Customer Support.
Read more...
Environment
- Microsoft Access
- SAP Data Services
Product
SAP Data Services 4.0 ; SAP Data Services 4.1 ; SAP Data Services 4.2 ; SAP Data Services XI 3.2
Keywords
office , direct , source , datastore , DB , KBA , EIM-DS , Data Services , EIM-DS-CON , Connectivity , How To
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.