* FILENAME :       BrowseConnect.c
*       Example uses SQLBrowseConnect to illustrate an iterative method of
*       discovering and enumerating the attributes and attribute values
*       required to connect to a data source.
#include <stdio.h>
#include <stdlib.h>
#include <sql.h>
#include <sqlext.h>
#include <string.h>

#include "util.c"

#define BRWS_LEN 1000

int main () {

    SQLHENV   henv  = SQL_NULL_HENV;   // Environment
    SQLHDBC   hdbc  = SQL_NULL_HDBC;   // Connection handle
    SQLHSTMT  hstmt = SQL_NULL_HSTMT;  // Statement handle
    SQLRETURN retcode;

    SQLCHAR strConnIn[BRWS_LEN], strConnOut[BRWS_LEN];
    SQLSMALLINT lenConnOut;

    // Allocate the environment handle.
    retcode = SQLAllocHandle(SQL_HANDLE_ENV, SQL_NULL_HANDLE, &henv);
    CHECK_ERROR(retcode, "SQLAllocHandle(SQL_HANDLE_ENV)",
                henv, SQL_HANDLE_ENV);

    // Set the version environment attribute.
    retcode = SQLSetEnvAttr(henv, SQL_ATTR_ODBC_VERSION,
                            (SQLPOINTER*)SQL_OV_ODBC3, 0);
                henv, SQL_HANDLE_ENV);

    // Allocate the connection handle.
    retcode = SQLAllocHandle(SQL_HANDLE_DBC, henv, &hdbc);
    CHECK_ERROR(retcode, "SQLAllocHandle(SQL_HANDLE_DBC)",
                hdbc, SQL_HANDLE_DBC);

    // Call SQLBrowseConnect until it returns a value other than SQL_NEED_DATA.
    // The initial call to SQLBrowseConnect is a DSN. If SQL_NEED_DATA is
    // returned, calls getStr (not shown) to build a dialog from the values in
    // strConnOut.  The user-supplied values are passed in the next call
    // to SQLBrowseConnect.

    strcpy((char*)strConnIn, "DSN=DATASOURCE"); // First call
    do {
        retcode = SQLBrowseConnect(hdbc, strConnIn, SQL_NTS, strConnOut,
                                   BRWS_LEN, &lenConnOut);
        if (retcode == SQL_NEED_DATA) {
            printf ("\nIn  Str : %s\n", strConnIn);
            printf ("\nOut Str : %s\n", strConnOut);
            getStr ("\nEnter Next Value", strConnIn, BRWS_LEN, 'N');
    } while (retcode == SQL_NEED_DATA);

    CHECK_ERROR(retcode, "SQLAllocHandle(SQL_HANDLE_DBC)",
                hdbc, SQL_HANDLE_DBC);


    printf ("\nComplete.\n");

    // Free handles
    // Connection
    if (hdbc != SQL_NULL_HDBC) {
        SQLFreeHandle(SQL_HANDLE_DBC, hdbc);

    // Environment
    if (henv != SQL_NULL_HENV)
        SQLFreeHandle(SQL_HANDLE_ENV, henv);

    return 0;

See Also

Oracle is a registered trademark of Oracle Corporation and/or its affiliates.