Skip to Content.
Sympa Menu

freetds - Re: [freetds] USE database in ODBC v3

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "ZIGLIO, Frediano, VF-IT" <Frediano.Ziglio AT vodafone.com>
  • To: "FreeTDS Development Group" <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] USE database in ODBC v3
  • Date: Tue, 16 Jan 2007 11:05:18 +0100

>
> 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?
>
> regards,
> Frederik.

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

freddy77





Archive powered by MHonArc 2.6.24.

Top of Page