I want to be able to either of two things.
1) Either create a DSN on the user's machine, or
2) Know the syntax for a DSN-less connection of the following DSN.
Here is the DSN that I want to transform in either case:
Data Source Name: CLS
Network Address: enterprise.capecod.net, 1433
Network Library: DBMSSOCN
uncheck User Trusted Connection
Database Name: CLS
Language Name: (Default)
checked Generate Stored Procedures for Prepared Statements
checked Use ANSI Quoted Identifiers
checked User ANSI Nulls, Padding and Warnings
uncheck Convert OEM to ANSI chracters