Sybase 12.4.2 User Manual

Introduction to 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 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