Chapter 3 Connection and Communication Parameters
49
♦ Connect to the default database from the C++ version of
Interactive SQL:
dbisqlc -c uid=dba;pwd=sql
View the application information:
select connection_property(’appinfo’)
The result is as follows (in a single string):
HOST=
machine-name
;
OS=Windows NT 4.0;
PID=0x11b;
THREAD=0x102;
VERSION=7.0.00.3642
♦ Connect to the default database from the C++ version of
Interactive SQL, appending your own information to the AppInfo
property:
dbisqlc -c "uid=dba;pwd=sql;app=ISQL connection"
View the application information:
select connection_property(’appinfo’)
The result is as follows (in a single string):
HOST=
machine-name
;
OS=Windows NT 4.0;
PID=0x10e;
THREAD=0xe1;
VERSION=7.0.00.3642;
APPINFO=ISQL connection
AutoStart connection parameter [Astart]
To prevent a local database server from being started if no connection is
found.
Anywhere
Yes
By default, if no server is found during a connection attempt, and a database
file is specified, then a database server is started on the same machine. You
can turn this behavior off by setting the AutoStart parameter to No or OFF in
the connection string.
Examples
Function
Usage
Default
Description