HANA SDA(smart data access) failed to connect to MS SQL Server

[Former Member]

Hi All,

Recently, I was trying to install SDA (smart data access) in my test HANA ( version: SPS11 1.0.110 ) to link to my test MS SQL server 2012. But it failed to display in HANA studio (check the following screenshot). But if I use cmd in HANA linux, it's sucessful.

I'm using the same version of driver install in SPS09 HANA, it works.

Tried another SPS11 HANA, it's the same symptom.

I followed the guideline to install with the correct version.

msodbcsql-11.0.2260.0.tar.gz  unixODBC-2.3.0.tar.gz

SAP guide

https://help.sap.com/saphelp_hanaplatform/helpdata/en/b4/91f9961e3348dc8c4bf96d66231954/content.htm

http://scn.sap.com/community/hana-in-memory/blog/2014/10/20/smart-data-access--basic-setup-and-commo...

Install Unix Driver Manager

https://msdn.microsoft.com/en-us/library/hh568449(v=sql.110).aspx

Install Microsoft ODBC guide:

https://msdn.microsoft.com/en-us/library/hh568454(v=sql.110).aspx

Download: Microsoft ODBC Driver 11

https://www.microsoft.com/en-us/download/details.aspx?id=34687

Download: Unix driver 2.3.0

http://www.unixodbc.org/pub/unixODBC/unixODBC-2.3.0.tar.gz

in the trace log, it will show the error while click "dbo" or refresh

[7214]{251486}[25/-1] 2016-08-30 17:29:30.341535 e FedTrace         odbcinfo.cpp(01348) : No mapping for ODBC type -150

[7196]{251487}[25/-1] 2016-08-30 17:29:31.177923 e FedTrace         odbcinfo.cpp(01348) : No mapping for ODBC type -155

Any advice or solution? Appreciate your answers.

Antti.

[former_member182967 · Accepted solution]

Hi Antti,

Maybe you missed the same error mentioned in .

Regards,

Ning

[Former Member · Accepted solution]

Hi Ning,

Really appreciate your answer. I'm downloading the latest SPS12 to update to test. Beside that, is there any other workaround without update? Thanks again.

Antti.

[former_member182967 · Accepted solution]

Hi Antti,

It is recommended to update HANA to latest patch level (rev or maintenance revision) to fix some known issues. Since you want to update to HANA SPS12, please directly go to 122.01. (Do not forget to update your HANA studio as well)

The workaround that Jimmy said is:

Regards,

Ning

[Former Member · Accepted solution]

Hi Ning,

Thank you very much for a quick response.

Finally, I updated to SPS12. 112.01, and it works. I didn't update HANA studio. attached screenshot for others reference.

Antti.