Discussion Locked

Creating a DSN in code

0 helpful
1 reply
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I want to create a dsn in Visual Basic Code not using a windows API is there a dll to use?

1 reply

by bojidar alexandrov

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.