ASA Database Administration Guide
Connecting to a Database
Introduction to connections
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 stringsInteractive 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. |