Finding The DSN To My Database?

sooprise picture sooprise · May 24, 2010 · Viewed 45.7k times · Source

I have an SQL database and want to connect to it using VBA in order to support some legacy functionality. I'm using an ADODB connection and need to know what my database DSN is. How can I find this?

I'm using SQL Server 2008, thanks! :D

Answer

egrunin picture egrunin · May 24, 2010

A DSN (data source name) is an indirect way of referring to the database. You have to create them manually (or semi-automatically using a wizard of some kind). Go to ControlPanel->AdministrativeTools->DataSources (ODBC) to see if one has already been defined for the database to which you want to connect.

But I think you might mean "connection string", not "DSN". There are many, many ways to tell ADODB how to find and connect to your database (DSNs are just one of those), but you always need a connection string.

I have often turned to ConnectionStrings.com to help me through the maze of similar-but-not-identical options.