error odbc connection in BODS

[Former Member]

Hi,

when i am trying to create new data store using odbc connection in bods. It showing error like

cant establish the odbc connection and [microsoft][ODBC excel driver] external table is in not expected format.

Thanks&Advance!

[DayaJha · Accepted solution]

Hi Kavya,

Please refer the below KBA regarding ODBC Error.

1371070 - BODI-1111341: WARNING: Cannot establish database connection. 'ODBC call <SQLDriverConnect> for data source <data source name> failed':- Data Services XI

https://service.sap.com/sap/support/notes/1371070

1876283 - ERROR: ODBC call <SQLDriverConnect> for data Source <> failed:<[Miscrosoft][ODBC SQL Server Driver][SQLServer]login failed for user - DS 4.x
https://service.sap.com/sap/support/notes/1876283

1666676 - Error: You receive "<[Microsoft][ODBC] Driver Manager] The specified DSN contains an architecture ...(BODI-1111341)" in datastore creation in Data Services
https://service.sap.com/sap/support/notes/1666676

Thanks,

Daya