create dsn runtime for sql server in vb.net

Question

hi all i want to create dsn runtime for sql server in vb.net pls help with code. thanks

Arun Sharma · Answer

Hi Vipin Use the following code to create a DSN at runtime: Dim str As String Dim ServerName As String = YourServerName Dim DatabaseName As String = YourDBName str = SERVER= & ServerName &  & Chr(0) str = Attr & DSN= & DatabaseName & Chr(0) str = Attr & DESCRIPTION=TestDSN & Chr(0) str = Attr & DATABASE=Test & Chr(0) str = Attr & TRUSTED_CONNECTION=No & Chr(0) SQLConfigDataSource(0 1 SQL Server str ) Take care Arun