Contents Index How connection parameters work Saving connection parameters in ODBC data sources

ASA Database Administration Guide
  Connecting to a Database
    Introduction to connections

Connection parameters passed as connection strings


Connection parameters are passed to the interface library as a connection string. This string consists of a set of parameters, separated by semicolons:

parameter1=value1;parameter2=value2;...

In general, the connection string built up by an application and passed to the interface library does not correspond directly to the way a user enters the information. Instead, a user may fill in a dialog, or the application may read connection information from an initialization file.

Many of the Adaptive Server Anywhere utilities accept a connection string as the -c option and pass the connection string on to the interface library without change. For example, the following is a typical Collation utility (dbcollat) command line (which should be typed all on one line):

dbcollat -c "uid=DBA;pwd=SQL;dbn=asademo" c:\temp\asademo.col
Interactive SQL connection strings 
Interactive SQL processes the connection string internally. These utilities do not simply pass on the connection parameters to the interface library. Do not use Interactive SQL to test command strings from the command prompt.

Contents Index How connection parameters work Saving connection parameters in ODBC data sources