Question Re: Linked Server on Sql Server 2017 in Technology Q&A

Linked Server on Sql Server 2017

Former Member — Sat, 02 Jun 2018 01:28:59 GMT

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.

Re: Linked Server on Sql Server 2017

dawn_kim — Mon, 04 Jun 2018 15:57:22 GMT

Hi Elsi,

We are not certified with this setup. Please note the oledb driver only comes in SDK 15.7 series. The oledb driver was dropped in the 16.0 series. Ref: https://archive.sap.com/documents/docs/DOC-56188.

Can you try the odbc driver and see if it works?

I need to test this setup with the oledb first and will get back with you.

Thanks,
Dawn Kim

Re: Linked Server on Sql Server 2017

Former Member — Tue, 05 Jun 2018 19:04:17 GMT

The odbc driver doesn't work.

Re: Linked Server on Sql Server 2017

dawn_kim — Thu, 07 Jun 2018 23:41:15 GMT

Hi Elsi,

I installed MSSQL 2017 and the Microsoft SQL Server Management Studio v 17.7 and using SDK 15.7 SP139 oledb driver. I am connecting to ASE 16 SP03 PL02.

I tested with the OLEDB driver from SDK 15.7 SP139 and it works.

So if you moved on the driver over did you do the following? Copy the whole folder? Did you start the command prompt as an administrator when you registered the drivers? Did you manually register the 32 and 64 bit oledb driver? When registering the 64 bit driver you make sure you are in the C:\windows\system32 directory and run the command regsrv32 C:\location of your driver\DataAccess64\OLEDB\sybdrvoledb.dll.
Are you calling the datasource you created? Or are you using a provider string?

I am having issues with the odbc driver though. Let me continue to test this though.

Thanks,
Dawn Kim

Re: Linked Server on Sql Server 2017

dawn_kim — Fri, 08 Jun 2018 21:50:40 GMT

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

Re: Linked Server on Sql Server 2017

sureshpaleti — Sat, 29 Jul 2023 04:39:54 GMT

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