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.