Need help creating an Sql Server System DSN programmatically in VB .NET

[brazilnut52]

I need help creating an Sql Server System DSN programmatically in VB .NET. I am writing a short install procedure for an app and it requires a few data sources to be setup. I would like to avoid having the clients setup the DSN themselves. I have found several code snippets on the net but none address a few configuration requirements I have.

 

When I ADD the DSN manually I:

Select Driver "SQL Server"

Give Name

Give Description

Select Server

Select "SQL Authentication" (given user name and password)

Select "Client configuration" -> uncheck "dynamically determine port" and type a number.

 

Is there anyway I can programmatically create and configure a DSN with these settings required? I need a little guidance.

 

Thanks