Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Finding The DSN To My Database?

Tags:

sql

vba

adodb

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

like image 637
sooprise Avatar asked May 24 '10 19:05

sooprise


1 Answers

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.

like image 77
egrunin Avatar answered Oct 28 '22 08:10

egrunin