etl error message

Hi everyone,

been a while
running version 9.2.7.23
just started getting a weird message

let me know

see attachments

Hi Alan.

I would try to install the latest version of SQL Server ODBC drivers first.
( Assuming that you are working with SQL server)

www.etl-tools.com/wiki/knowledgebase/tip...server-odbc-drivers/

(I can connect remotely and investigate if you wish later today or even over the weekend.)

Mike,

We are getting more and more of the ODBC 17 error.
As far as I know, we don't use it, at least I have not set up a connection using it
I have your last email on updating our ODBC and SQL connections
These updates are done on the server that hosts the etl software correct?

These updates are done on the server that hosts the etl software correct?

Correct

We do not have the ODBC 17 defined to our systems. We only use sql server connection or a Progress database odbc connect provided by Progress. Yet we are always getting the error message:
Failed to connect sqldriver connect failed 08001 [microsoft][odbc driver 17 for sql server] ssl provider: an existing connection was forcably closed by remote host. client unable to establish connection

Why/How are we getting this if the driver is not defined to ETL and not in our ODBC connection list?

Hi Alan

SQL server connection is using "ODBC driver for SQL Server" to connect to SQL server.
Our software is using the "Highest available SQL server driver" in the following order

ODBC Driver 17 for SQL Server
ODBC Driver 13 for SQL Server
ODBC Driver 11 for SQL Server
SQL Server Native Client 11.0
SQL Server Native Client 10.0
SQL Native Client
SQL Server



Here is the user is having similar problems to yours

social.msdn.microsoft.com/Forums/sqlserv...r2019?forum=sqltools .

You may try removing ODBC driver 17 to see if it helps to solve the problem