Error connectiong to Remote Source MSSQL ODBC

[Former Member]

Hi everyone,

I try to create a Remote Data Source in HANA Studio for a MSSQL ODBC connection.

If I try to verify my connection following error message appears:

SAP DBTech JDBC: [403]: internal error: Cannot get remote source objects: Could not find .odbc.ini in /usr/sap/HDB/home or /usr/sap/HDB/HDB00

I copied the odbc-file already to both directories....

Before I installed

     unixODBC

     Microsoft ODBC

With isql I can successfully query my tables via the odbc connection.

Any idea?

Thanks in advance!

Ulf

[Former Member]

Hello,

Make sure you copy odbc.ini file to either /usr/sap/HDB/home or /usr/sap/HDB/HDB00  and rename it to '.odbc.ini' (yes, with a dot).

You may get another error say it could not load the driver location (because on the video of HANA Academy, the instructor used root home folder). So you could look up the real location when install mssqlODBC driver by looking up on '/etc/odbcinst.ini . Mine is  /opt/microsoft/msodbcsql/lib64/libmsodbcsql-11.0.so.2260.0

I grabbed this and pasted into /usr/sap/HDB/HDB00/.odbc.ini . Works like a charm.

Hope this help.

[former_member183029]

Hello,

Thank you very much for your inputs. Works for me!

Regards,

Subhankar