From the HCO for SQL Server interface, click
Manage Connections.
From the
Connection List tab, select a
Connection Type -
Azure,
System or
User - to populate the
Connection List grid with connections defined for that type.
From the
Connection List grid, select a connection that shows a status other then OK or Unknown for at least one connection type. SQL Server connections
indicate status for 32- or 64-bit ODBC and 32- or 64-bit CLR 2 or 4 ADO.NET connection types. DB2 connections show 32- and
64-bit CLR 2 and 4 ADO.NET connection types.
Important:ODBC provider selection for SQL Server connections applies to System or User connections. Azure connections do not use ODBC
connections. The "SQL Server" ODBC provider from Microsoft is an older provider that ships with Microsoft Windows and lacks
certain features available in many newer Microsoft ODBC providers. As such, it is not shown in Manage Connections ODBC drop-down
selectors. Microsoft ODBC provider versions provide support for particular versions of SQL Server. To help you select an appropriate
ODBC provider,
System requirements, installation, and driver files page on the Microsoft Web site.