[freetds] USE database in ODBC v3
ZIGLIO, Frediano, VF-IT
Frediano.Ziglio at vodafone.com
Tue Jan 16 05:05:18 EST 2007
> Hi all,
> I'm writing an application where I need data from 2 databases
> on the same
> server. The problem I have is how to switch from one database
> to the other.
> The only thing I found in the ODBC documentation is something
> like this:
> SQLSetConnectAttr( connection, SQL_ATTR_CURRENT_CATALOG,
> (SQLPOINTER)MY_DB_NAME, sizeof(MY_DB_NAME));
> But according to the documentation this only works with ODBC
> v2 and I'm
> using ODBC v3. And indeed, this is not working in my application.
> Does anybody know how to do this?
Should work even on odbc v3. Note that should be strlen(MY_DB_NAME), not
sizeof(MY_DB_NAME), or, if MY_DB_NAME is #defined as a constant strings
should be sizeof(MY_DB_NAME)-1
More information about the FreeTDS