Skip to Content
avatar image
Former Member

Error connectiong to Remote Source MSSQL ODBC

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Sep 11, 2014 at 04:57 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded