Hi
I Tried to create DSN from VB code but fails
Using Odbctool.dll - from
C:\Program Files\Microsoft Visual Studio
Code is as follows,returns true but no DSN created
Dim objOdbc As New ODBCTool.Dsn
Dim retc As Boolean
retc = False
retc = objOdbc.CreateDSN("TEST_DSN", "SQL Server", "LOCAL_SERVER_NAME", "DB_NAME", "sa", "", _
"DSN Desc test", False, ""
I Tried to create DSN from VB code but fails
Using Odbctool.dll - from
C:\Program Files\Microsoft Visual Studio
Code is as follows,returns true but no DSN created
Dim objOdbc As New ODBCTool.Dsn
Dim retc As Boolean
retc = False
retc = objOdbc.CreateDSN("TEST_DSN", "SQL Server", "LOCAL_SERVER_NAME", "DB_NAME", "sa", "", _
"DSN Desc test", False, ""