cancel
Showing results for 
Search instead for 
Did you mean: 

ODBC call for data source failed: <[Microsoft][ODBC Driver Manager]

0 Kudos

Hello Experts,

We have SAP HANA Express Edition 2.0 SPS3 on premise, HANA Client for the same (We have upgraded the client for HANA 2.0 SPS3) and SAP Data Services 4.2 SP9. We created data store for SAP HANA using DSN. DSN is created using HDBODBC driver and the connection test was successful.

In data store for SAP HANA, we are not able to see tables in HANA but we can see views created on top of it. When we executed a job, it gave following error :

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

Please assist.

Thanks,

Niranjan

HakanHaslaman
Product and Topic Expert
Product and Topic Expert
0 Kudos

Thanks Hakan,

The error was resolved when I renamed DSN to "HDBODBC" from "HANA". Is this the correct way to configure DSN for HANA?

Regards,

Niranjan

Accepted Solutions (0)

Answers (0)