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...

No comments:

Post a Comment