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.
SAP Knowledge Base Article - Preview