SQL Native client && ODBC v 17 on SQL12 & 16.

  • snomadj

    SSCarpal Tunnel

    Points: 4262

    Is there any reason not to install both of these on the same servers.  If i do, how do I know how / which my application is using to connect with.

     

    I'm aware this sounds like a strange question but it's an upgrade requirement for a server app with various versions of client apps connecting in.

  • Grant Fritchey

    SSC Guru

    Points: 395846

    You can install both. Connections will be completely dependent on the defined connection string. If you define the ODBC driver, that's what will get used. If you define the native ODBC client, that's what gets used. Personally, I hate installing older versions of client connectivity like the native ODBC client, but I get it that sometimes you have to.

    ----------------------------------------------------
    The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood...
    Theodore Roosevelt

    The Scary DBA
    Author of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd Edition
    Product Evangelist for Red Gate Software

  • snomadj

    SSCarpal Tunnel

    Points: 4262

    Perfect, thank you Grant.  I appreciate the response!

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply