Here is a handy web site, if you don't already know about it.
http://www.connectionstrings.com/Gary
>>>I am looking for a way to create a system DSN via code. We are migrating to SQL server. Currently, we will be pulling static history from SQL server for reports. To aid in the upgrading, I am looking for a way to generate the ODBC System DSN.
>>
>>If it is ODBC why not use SQLSTRINGCONNECT()?
>
>That was my first thing I looked at. But I can connect via DNS, but not through a connection string directly using the same parameters. Do know of anything that could be different that I am missing?