Skip to Content
0
Jun 02, 2018 at 01:28 AM

Linked Server on Sql Server 2017

551 Views

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.