SAP Knowledge Base Article - Preview

1584075 - Is Microsoft Access database a supported a data source? - Data Services

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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.