I use the following code to build my connection string in VB.net:
Dim BuildConnectionString As String
BuildConnectionString = "DSN=" + g_DSNName + ";UID=" + g_UserId + ";PWD=" + g_Password
Dim odbcConnect As New OdbcConnection(BuildConnectionString)
Being that my DSN is set-up with sa, I am not really sure I fully understand how the connection string actually works.
Is the UID and PWD, used in the connection string, the ones in the DSN or is the UID and PWD for connecting to the database once the DSN gets
you to the server?