DSN-less configuration

Example 4-1. Sample files for a DSN-less configuration

The odbcinst.ini is quite brief:

	;
	; odbcinst.ini
	;
	[FreeTDS]
	Driver = /usr/local/freetds/lib/libtdsodbc.so
	

The freetds.conf might look something like:

	;
	; freetds.conf
	;
	[JDBC]
        	host = jdbc.sybase.com
        	port = 4444
        	tds version = 5.0
	

Example 4-2. Connecting with a DSN-less configuration

/*
 * application call
 */
const char servername[] = "JDBC"; [1]
sprintf(tmp, "DRIVER=FreeTDS[2];SERVERNAME=%s;UID=%s;PWD=%s;DATABASE=%s;", 
	servername, username, password, dbname);
res = SQLDriverConnect(Connection, NULL, (SQLCHAR *) tmp, SQL_NTS, 
			(SQLCHAR *) tmp, sizeof(tmp), &len, SQL_DRIVER_NOPROMPT);
if (!SQL_SUCCEEDED(res)) {
	printf("Unable to open data source (ret=%d)\n", res);
	exit(1);
}

Example 4-3. Connecting with a DSN-less configuration that does not use freetds.conf

/*
 * application call
 */
const char servername[] = "jdbc.sybase.com"; [3]
sprintf(tmp, "DRIVER=FreeTDS[4];SERVER=%s;UID=%s;PWD=%s;DATABASE=%s;TDS_Version=5.0;Port=4444;", 
	servername, username, password, dbname);
res = SQLDriverConnect(Connection, NULL, (SQLCHAR *) tmp, SQL_NTS, 
			(SQLCHAR *) tmp, sizeof(tmp), &len, SQL_DRIVER_NOPROMPT);
if (!SQL_SUCCEEDED(res)) {
	printf("Unable to open data source (ret=%d)\n", res);
	exit(1);
}