|Subject:||Using ODBC connection string to establish connection|
|Creation date:||7/29/09 4:48 PM|
|Last modified on:||7/29/09 4:48 PM|
A connection string is a set of connection parameters that tell WinSQL how to connect to a remote database. If you want to use a connection string for connecting to a database, or if your application requires it, you must specify a DSN (data source name), a File DSN, or a DSN-less connection in the string. The difference is whether you use the DSN=, FILEDSN=, or the DRIVER= keyword in the connection string, as described in the ODBC specification. A DSN or FILEDSN connection string tells the driver where to find the default connection information. Optionally, you may specify attribute=value pairs in the connection string to override the default values stored in the data source.
Beginning with ODBC Administrator version 4.0, a DSN is not required to establish a database connection. To use a connection string rather than a DSN connection, click the Specify connection string check box. The following window is displayed:
Choose one of the following connection string types and use the accompanying format as an example for creating your entry: