Author Topic: WebConfig sees most recent SQL drivers as '(old)'  (Read 12520 times)

aldr1c

  • EA User
  • **
  • Posts: 33
  • Karma: +1/-0
    • View Profile
WebConfig sees most recent SQL drivers as '(old)'
« on: May 02, 2019, 03:50:41 pm »
in the process of migrating our services and when recreating the database connection managers, I get SSL errors when trying to use the ODBC for SQL Server drivers (most recent possible, with SQL Server 2017 SSMS on a SQL Server 2016 Std platform).  I can use the native SQL client to set up the connection, however when I try to save the manager settings, i get an invalid connection string error.  I can manually change the string then to the old style SQLOLEDB and it lets me save (and doesn't flag as '(old)').

Can anyone explain what is happening under the hood?  I am at a loss really.  Ideally we would use the webconfig client (less logging onto the servers themselves), however this behaviour seems a bit inconsistent.

any ideas appreciated.

Eve

  • EA Administrator
  • EA Guru
  • *****
  • Posts: 8054
  • Karma: +118/-20
    • View Profile
Re: WebConfig sees most recent SQL drivers as '(old)'
« Reply #1 on: May 02, 2019, 04:29:51 pm »
Neither EA or the cloud server has ever handled connecting to a model on SQL Server using the ODBC drivers.

You have two options:
'Microsoft OLE DB Provider for SQL Server', which has been included by default since Windows XP.
'Microsoft OLE DB Driver for SQL Server', which is downloadable from Microsoft but supports options like connecting over TLS 1.2