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
A:
There may not be a DSN. DSNs are not created automatically.
I'm not sure you really mean DSN, as a DSN is an ODBC concept. Still, look in Administrative Tools->Data Sources (ODBC).
John Saunders
2010-05-24 19:18:21
If there is a DSN, how can I find it?
Soo
2010-05-24 19:34:40
Control Panel->Administrative Tools-> Data Sources (ODBC)
Adam Driscoll
2010-05-24 19:39:01
+3
A:
A DSN 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 you want to connect to.
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 similar-but-not-identical options.
egrunin
2010-05-24 19:36:43