1 reply
You must set values for the DSN in the registry. Here is piece of code written in VB Script. You can translate it to VB.
Dim obFileSys, obDSN, WSHShell, DefaultODBCDir
Set WSHShell = WScript.CreateObject("WScript.Shell")
DefaultODBCDir = WSHShell.RegRead("HKLM\Software\ODBC\ODBC.INI\ODBC File DSN\DefaultDSNDir")
Set obFileSys = WScript.CreateObject("Scripting.FileSystemObject")
Set obDSN = obFileSys.CreateTextFile(DefaultODBCDir & "\" & strDSNName)
obDSN.WriteLine("[ODBC]")
obDSN.WriteLine("DRIVER=SQL Server")
obDSN.WriteLine("UID=" & m_strLoginID)
obDSN.WriteLine("PWD=" & m_strPassword)
obDSN.WriteLine("DATABASE=" & strDatabase)
obDSN.WriteLine("WSID=" & m_strServername)
obDSN.WriteLine("APP=Microsoft Win32")
obDSN.WriteLine("SERVER=" & m_strServername)
obDSN.Close
This discussion is closed to new replies.
Trending Web Development posts
Sort by Trending