/**********************************************************************
* FILENAME :        ListDrivers.c
*
* DESCRIPTION :
*                   Example to list the ODBC Drivers available
*
* ODBC USAGE :
* 		    Loop until no more data
*	 	    SQLDrivers - with direction = SQL_FETCH_FIRST first
*                   time and with direction = SQL_FETCH_NEXT
*	 	    subsequently prints driver name
*/
#include <stdio.h>
#include <stdlib.h>
#include <sql.h>
#include <sqlext.h>
#include <string.h>

#include "util.c"

int main () {

    SQLHENV  henv  = SQL_NULL_HENV;   	// Environment
    SQLRETURN retcode;			// Return status

	char driver[256];
	char attr[256];
	SQLSMALLINT driver_ret;
	SQLSMALLINT attr_ret;
	SQLUSMALLINT direction;

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

    // Set ODBC version
    retcode = SQLSetEnvAttr(henv, SQL_ATTR_ODBC_VERSION,
                                            (void *) SQL_OV_ODBC3, 0);
    CHECK_ERROR(retcode, "SQLSetEnvAttr(SQL_ATTR_ODBC_VERSION)",
                henv, SQL_NULL_HANDLE);

	// Call SQLDrivers to return ODBC Drivers
	direction = SQL_FETCH_FIRST;
	while(SQL_SUCCEEDED(retcode = SQLDrivers(henv, direction,
						 driver, sizeof(driver),
                                                 &driver_ret, attr,
                                                 sizeof(attr), &attr_ret))) {
	    direction = SQL_FETCH_NEXT;

		printf("%s - %s\n", driver, attr);
		CHECK_ERROR(retcode, "SQLDrivers()", henv, SQL_NULL_HANDLE);
	}
exit:
    printf ("\nComplete.\n");

    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.