This section describes how the interface libraries establish connections.
In many cases, establishing a connection to a database is straightforward using the information presented in the preceding sections of this chapter. However, if you are having problems establishing connections to a server, you may need to understand how Sybase IQ establishes connections in order to resolve your problems.
For more information on resolving connection problems, see Sybase IQ Troubleshooting and Recovery Guide.
If you have no problem establishing connections to your
database, you do not need to read this section.
The software follows exactly the same procedure for each of the following types of client application:
Any ODBC application using the SQLDriverConnect function, which is the common method of connection for ODBC applications. Many application development systems, such as Sybase PowerBuilder and Power++, belong to this class of application.
Any client application using Embedded SQL and using the recommended function for connecting to a database (db_string_connect).
The SQL CONNECT statement is available for Embedded SQL applications and in Interactive SQL. It has two forms: CONNECT AS... and CONNECT USING... . All the database administration tools, including utilities and Interactive SQL, use db_string_connect.
