Share via

Which ODBC version is compatible of SQL server 2019

Saidulu Kodidala 6 Reputation points
2022-05-20T05:26:12.377+00:00

Which ODBC version is compatible of SQL server 2019

We are using the 2019 SQL version and have encountered the SQL job termination issue due to an ODBC driver issue and it's working on SSIS package level(jobs are being terminated when we use the 2016 ODBC version and jobs are being worked while using the 2010 ODBC driver)

Can anyone please help me figure out which ODBC version is compatible of SQL server 2019

Thanks,
Saidulu
8096086266

SQL Server | Other
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. CathyJi-MSFT 22,426 Reputation points Microsoft External Staff
    2022-05-20T09:48:33.04+00:00

    Hi @Saidulu Kodidala ,

    Quote from MS document;
    204073-screenshot-2022-05-20-174553.jpg

    Suggest you using the latest version of ODBC driver.

    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    1 person found this answer helpful.
    0 comments
  2. Olaf Helper 47,616 Reputation points
    2022-05-20T05:54:29.507+00:00

    Every supported ODBC Driver for SQL Server supports every supported SQL Server version.
    But it's always the best to use the latest ODBC version.
    https://learn.microsoft.com/en-us/sql/connect/odbc/download-odbc-driver-for-sql-server?view=sql-server-ver15

    And for the rest of your post:
    To less and very vague information, so no one can guess existsing issues and how to overcome them.
    So please provide more detailed informations.

    1 person found this answer helpful.

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.