beautypg.com

Connection parameters specify connections – Sybase 12.4.2 User Manual

Page 72

background image

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 ...