etl error message

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

Mike,
you were correct, the MS ODBC 17 is in our stack, but we do not have any connections using it
we use the sql server, a progress odbc.

Are you saying ETL will attempt to use odbc 17, even if we do not have any etl connections using it?
Should we be using the ms odbc 17 instead of the sql server connection?

I am really struggling to understand your question.

"But we do not have any connections using it
we use the sql server, a progress odbc."

Does it means that you have two connections eg "SQL server and progress odbc"?

I am sorry for not being clear
We have many sql server connections pointing to our many databases. 99% of these are using the sql sever connection, a couple sql server native client 11.0.
We have many progress connections for the Progress database
We do not have any ETL connections using MS ODBC 17, yet we get the error message.
That is what I do not understand
Should we change from sql server connection and use the MS ODBC 17 ?

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

Connection process

Do we have ODBC Driver 17 for SQL Server installed? if so let's load the driver and connect it to the SQL server
If not
Do we have ODBC Driver 13 for SQL Server installed? if so let's load the driver and connect it to the SQL server
If not
Do we have ODBC Driver 11 for SQL Server installed? if so let's load the driver and connect it to the SQL server
If not
Do we have SQL Server Native Client 11.0 installed? if so let's load the driver and connect it to the SQL server
If not
Do we have SQL Server Native Client 10.0 installed? if so let's load the driver and connect it to the SQL server
If not
Do we have SQL Native Client installed? if so let's load the driver and connect it to the SQL server
If not
Do we have SQL Server installed? if so let's load the driver and connect it to the SQL server