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

  • 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.

  • 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

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

  • Perfect, thank you Grant.  I appreciate the response!

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

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