<div>
Thanks that looks like what I needed. &nbsp;The first one is probably the one I'll use.<br />
<br />

</div>


Thanks that looks like what I needed.  The first one is probably the one I'll use.



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


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
Description:
Server:             Enterprise
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

Creating a DSN on a user's machine or a DSNless connection

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.