HANA SDA connection to MSSQL 2012

[Former Member]

Hi All,

I am in the process of configuring HANA SDA connection to MSSQL 2012. Have both unixODBC dirvers and MSODBCdrivers in place.

Below is the error I get into.

JDBC: [403]: internal error: Cannot get remote source objects :[unixODBC][Driver manager] Data source name not found, and no default driver specified

Checked the odbc.ini file at installation location, it contains no data. copied file to .odbc.ini and added below two lines

[HDB]

Driver=/usr/sap/HD1/home/libmsodbcsql-11.0.so.2260.0

ServerNode=XXX:Port

Did I missed anything here?

Regards,

Raj

Message was edited by: Tom Flanagan

[Former Member · Accepted solution]

This connection is working fine after opening a static port on MSSQL Server.

Regards,

Raj

[henrique_pinto · Accepted solution]

This message was moderated.

[former_member288197]

Hello Raj,

Can you please share the config you have done here ?

Thanks,

Daniel

[Former Member]

Below trace file is from HANA Administration consle.

Any idea why timeout error occurs?

need your inputs please.

Does timezone difference matters to establish connection between MSSQL server & HANA DB

Regards,

Raj

[srinivasan_vinayagam]

Hi Raj,

You can add environment variable in odbc.ini file as per below guide.

https://websmp203.sap-ag.de/~sapidb/012006153200000561122013E/HANA_smart_data_access_drivers.pdf

Regards,

V Srinivasan

[Former Member]

Srinivasan,Thanks for reply.

I have maintained environment variables as per blog

export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/opt/microsoft/msodbcsql/lib64

export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/usr/local/lib

export ODBCINI=$HOME/.odbc.ini

Below is the DSN entry in .odbc.ini [SIDadm:sapsys - 777]

                    [MSSQL]

                    Driver=/opt/microsoft/msodbcsql/lib64/libmsodbcsql-11.0.so.2260.0

                    Server=10.X.X.X,1433
                   

Restarted Server, after creating new remote connection I get below error

Regards,

Raj

[Sriram2009]

Hi Raj

I am not sure could you check this SCN link,

BR

SS