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 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

[Former Member]

The odbc driver doesn't work.