The DSN would be the ODBC data source that is setup to the SQL Server. In this example the password is blank. The Initial Catalog is the name of the database where the data is located.
If do not want to hard code this information, there is a dll file that can be used to retrieve all this information. This .dll file can be found on PartnerSource or CustomerSource under Downloads & Updates | Product Releases | Continued in eEnterprise Product Releases | Modifier/VBA Samples. The file is called .
The readme file that is included will show you how to declare the variables to use the dll file. An example of code would declare variables and then use the variables in the connection string.
Dim userinfo As Object Dim luserid As String Dim lsqlpassword As String Dim lintercompanyid As String Dim lsqldatasourcename As String