Choose an ODBC Connection Function

ODBC supplies a set of connection functions.

Which of these functions you use depends on how you expect your application to be deployed and used:

SQLConnect – the simplest connection function

SQLConnect – takes a datasource name (DSN), and an optional user ID and password. You might want to use SQLConnect if you hard-code a datasource name into your application.

For more information, see SQLConnect in the Microsoft ODBC Programmer's Reference.
SQLDriverConnect – connects to a datasource using a connection string

SQLDriverConnect – allows the application to use Adaptive Server Enterprise-specific connection information that is external to the datasource.

Note: On UNIX, the Adaptive Server ODBC Driver supports only SQL_DRIVER_NOPROMPT.

You can also use SQLDriverConnect to connect without specifying a datasource.

For more information, see SQLDriverConnect in the Microsoft ODBC Programmer's Reference.
SQLBrowseConnect – connects to a datasource using a connection string, like SQLDriverConnect.

SQLBrowseConnect – allows your application to build its own dialog boxes to prompt for connection information, and to browse for datasources used by a particular driver in this case, the Adaptive Server ODBC Driver.

For more information, see SQLBrowseConnect in the Microsoft ODBC Programmer's Reference.