Linked Server on Sql Server 2017

[Former Member]

Need help with recommendation on ASE driver to connect with Sql Server 2017. We had tested at one point with 2012 Sql and ASE OLEDB connection and that works perfectly. We tried to test with the same installation but seems like the OLEDB won't install correctly. The developer version of ASE we tested with is, display_version=15.7 SP101 internal_version=15.7.0.101000. We need to use Linked Server from Sql Server 2017 using the ASE OLEDB driver. we tried to copy over the OLEDB folder and register the dll's manually, the connection worked but it times out intermittently.

So i downloaded a few of the trial versions to test but cannot the connection from the Linked server cannot be established. Cannot initialize the Data source error [Sql Error 7303]. The newer versions that i tested with are:

display_version=16.0 SP02 PL05 internal_version=16.0.020.0500

display_version=16.0 SP01 PL01 internal_version=16.0.010.0100

display_version=16.0 SP03 GA internal_version=16.0.030.0000

display_version=15.7 SP138 internal_version=15.7.0.138000

Any help is much appreciated.

[dawn_kim]

Hi,

I was able to get the odbc driver to work also. It wasn't saving my password causing my issue. The one problem I did notice is not all the tables are listed. So I need to figure that out and write a CR on that. Still testing this though.

Thanks,
Dawn Kim

[sureshpaleti]

Hi Kim

Are you able to write a query in sql linked server to access data from SAP hana

example what would be the query if i want to access data from table MARA, MSEG,BSEG

Select * from <?????>.MARA

Regards,

Srinithi