ODBC interface allows SSMS to connect to ODBC databases using the SQL language. Additionally, we have designed Advanced Connection String parameters that implement different types of behavior.
Is SSMS ODBC?
SQL Server Management Studio is an ideal environment for managing infrastructure of SQL Server database and SQL Server itself. … Besides this, there is a possibility to create an ODBC connection to external data from SSMS. Thus, you can work with other databases and clouds used by your applications.
Which driver does SSMS use?
Connect from SQL Server Management Studio SQL Server Management Studio uses the SQL Server Client OLE DB provider, which requires the ODBC driver to be used inprocess.