create dsn runtime for sql server in vb.net

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