• Products >
• Support >
• Solutions
• Company
• Blog

• < Back
• ODBC drivers >
• JDBC drivers >
• Bridges, gateways >
• Other >
• All products

• < Back
• JDBC-ODBC Bridge
• JDBC-Access Gateway

• < Back
• ODBC-ODBC Bridge
• ODBC-JDBC Gateway
• dbExpress-ODBC Gateway
• XML-ODBC Server

• < Back
• ODBC-ODBC Join Engine
• SDK
• Consultancy
• Roadmap

/**********************************************************************
* 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 ;
}

Further information

• ODBC code samples