Introduction to connections

If you want ...

Consider reading ...

A conceptual overview

“Connection parameters specify

 

connections”

 

 

To create data sources

“Working with ODBC data sources”

 

 

To see an in-depth description of how

“Working with ODBC data sources”

connections are established

 

 

 

To add users and grant them permissions

“How Adaptive Server IQ makes

 

connections”

 

 

To diagnose network-specific connection

“Troubleshooting network

issues

communications” in the Adaptive Server

 

IQ Troubleshooting and Error Messages

 

Guide

 

 

To learn about character set issues

“Connection strings and character sets”

affecting connections

on page 338

 

 

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

This chapter has many examples of connection strings, represented in the

connection strings

following form:

 

 

parameter1=value1

 

parameter2=value2

 

...

 

This is equivalent to the following connection string:

 

parameter1=value1;parameter2=value2

52

Page 72
Image 72
Sybase 12.4.2 manual Connection parameters specify connections, Connection parameters are passed as connection strings