Avatar of jana
Flag for United States of America

asked on 

Use MS Sql Management Studio to read non-sql database thru ODBC

Is there a way to setup our MS Sql management Studio (2005 or 2014) to connect to a non-mssql database (or external data source) using an OBDC connector?  We have an ODBC driver for a database that is not a Microsoft SQL database njor a Microsoft product.  The ODBC driver has it's own "query" section that we can query the non-sql databases but we wanted to see if we can use MSSQL Studio to run our queries.

Can we setup our MS Sql Studio to connect to a database via ODBC? is this possible? How can we go about it?
Microsoft SQL Server

Avatar of undefined
Last Comment

8/22/2022 - Mon