Filter
Top Products
Introduction to connections
52
Connection parameters specify connections
When an application connects to a database, it uses a set of connection
parameters to define the connection. Connection parameters include
information such as the server name, the database name, and a user ID.
A keyword-value pair, of the form parameter=value, specifies each connection
parameter. For example, you specify the password connection parameter for
the default password as follows:
Password=sql
Connection parameters are passed as connection strings
Connection parameters are assembled into connection strings. In a connection
string, a semicolon separates each connection parameter, as follows:
ServerName=host_asiqdemo;DatabaseName=asiqdemo
Representing
connection strings
This chapter has many examples of connection strings, represented in the
following form:
parameter1
=
value1
parameter2
=
value2
...
This is equivalent to the following connection string:
parameter1
=
value1
;
parameter2
=
value2
A conceptual overview “Connection parameters specify
connections”
To create data sources “Working with ODBC data sources”
To see an in-depth description of how
connections are established
“Working with ODBC data sources”
To add users and grant them permissions “How Adaptive Server IQ makes
connections”
To diagnose network-specific connection
issues
“Troubleshooting network
communications” in the Adaptive Server
IQ Troubleshooting and Error Messages
Guide
To learn about character set issues
affecting connections
“Connection strings and character sets”
on page 338
If you want ... Consider reading ...