>>Has anyone been able to use the SQLConfigDataSource() function to programmatically create and configure an ODBC data source for SQL Server? I have a feeling I'm real close, but...
>>
>>tia,
>
>What helped me was the Connection Designer. I had it build me a new connection string. Then I took that string to parse out the various parameters. I also used the ODBC Admin to create a DSN, then went into the Registry to get a list of all the parameters I could specify. Specifically you have to use the exact description of the ODBC driver to use [e.g. Microsoft ODBC for Oracle]. I believe, in your case, you must use SQL Server.

Thanks Mark. I had the SQL Server part right. I was missing (like a big dummy) the DSN. After I got it to work using an example in the MS KB, I got it figured out. Thanks again.