Showing posts with label proprietary. Show all posts
Showing posts with label proprietary. Show all posts

Saturday, February 25, 2012

Connecting SQL Server Management Studio to an ODBC DSN

I'm not even sure if this is possible ... but here is my scenario:

We use a proprietary database. The database vendor wrote an ODBC driver which works well. So I have code that can connect to the database, do queries, etc. Can I use SQL Server Management Studio to connect to an ODBC DSN?

Ideally I would like to use the Object Browser and "Query Analyzer" (or whatever it's called) against the tables in this database.

Any help would be greatly appreciated.

Thanks.

-Aaron

No, SSMS only works against SQL Server 2000 and 2005.

The Tools forum is probably more appropriate for this question.

|||Moving the thread...