none
SQL Native Client 11 not available when creating ODBC 64bit connection?

    Question

  • I've installed SQL server 2012 and Native client installed as part of that, I see it in Programs, version 11.3.6020.0...on W2K12R2.  Firewall turned off and SQL browser service running.

    I've manually created a database called vcenter, and on a separate W2K12R2 VM I am creating a System DSN ODBC connection.

    However, I only see SQL Server as a selection.  I do not see SQL Server Native Client which is required for ODBC connection and VMware vcenter install. 

    Any suggestions for how to make SQL Native client available as selectable option when creating ODBC connection?

    I've done it before, just don't remember what I am missing.

    Thanks, romatlo

    Saturday, January 7, 2017 11:13 PM

Answers

  • You need to install SQL Server Native Client on the W2K12R2 VM, not just on the server.

    Note that SQL Server Native Client is deprecated after SQL Server 2012 in favor of the later stand-alone ODBC drivers (https://msdn.microsoft.com/en-us/library/cc280510%28v=sql.130). The latest SQL Server ODBC driver is "ODBC Driver 13.1 for SQL Server" and can be download from https://msdn.microsoft.com/library/mt703139.aspx. Unlike SNAC, this is supported against SQL Server 2012 and later versions.


    Dan Guzman, Data Platform MVP, http://www.dbdelta.com

    • Marked as answer by romatlo Sunday, January 8, 2017 2:20 PM
    Saturday, January 7, 2017 11:28 PM

All replies

  • You need to install SQL Server Native Client on the W2K12R2 VM, not just on the server.

    Note that SQL Server Native Client is deprecated after SQL Server 2012 in favor of the later stand-alone ODBC drivers (https://msdn.microsoft.com/en-us/library/cc280510%28v=sql.130). The latest SQL Server ODBC driver is "ODBC Driver 13.1 for SQL Server" and can be download from https://msdn.microsoft.com/library/mt703139.aspx. Unlike SNAC, this is supported against SQL Server 2012 and later versions.


    Dan Guzman, Data Platform MVP, http://www.dbdelta.com

    • Marked as answer by romatlo Sunday, January 8, 2017 2:20 PM
    Saturday, January 7, 2017 11:28 PM
  • Thank you!
    Sunday, January 8, 2017 2:21 PM