Skip to Content.
Sympa Menu

freetds - Re: [freetds] Squirrel JDBC-ODBC Bridge and freeTDS ODBC

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Зверев Виталий Борисович <VZverev AT genesis.spb.ru>
  • To: "FreeTDS Development Group" <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] Squirrel JDBC-ODBC Bridge and freeTDS ODBC
  • Date: Tue, 8 Nov 2005 00:30:39 +0300

Thanks Frediano,
it works pefect now for getSchemas() and getCatalogs().
However the setCatalog() probably was broken in Squirrel 2.0 rc1 from
scratch.
If somebody interesting about workaround it in odbc.c, the next patch may be
suitable:
bash-2.03$ diff -c CVS/odbc.c odbc.c
*** CVS/odbc.c Tue Nov 8 00:08:22 2005
--- odbc.c Tue Nov 8 00:15:28 2005
***************
*** 219,224 ****
--- 219,230 ----
{
TDSSOCKET *tds = dbc->tds_socket;

+ if (database[0]=='"' && database[database_len-1]=='"' &&
database_len>2){
+ database[database_len-1]='\0';
+ database++;
+ database_len--;
+ database_len--;
+ };
/*
* We may not be connected yet and dbc->tds_socket
* may not initialized.
bash-2.03$

Sincerely yours.
-------------------------------------------------------
Vitaly Zverev, OCP DBA 8&8i
Oracle E-Business Suite &
Infiniband Linux Cluster Administrator
Genesis Ltd., St.Petersburg, Russia



> -----Original Message-----
> From: freetds-bounces AT lists.ibiblio.org
> [mailto:freetds-bounces AT lists.ibiblio.org] On Behalf Of
> Frediano Ziglio
> Sent: Saturday, November 05, 2005 11:31 AM
> To: FreeTDS Development Group
> Subject: Re: [freetds] Squirrel JDBC-ODBC Bridge and freeTDS ODBC
>
> Il giorno ven, 04/11/2005 alle 18.26 +0300, Зверев Виталий
> Борисович ha
> scritto:
> > No, if you mean "odbc.c,v 1.395 2005/11/02 12:57:54 freddy77" from
> > CVS, it does not solve JdbcOdbc bridging problems with
> DatabaseMetaData.getSchemas(),DatabaseMetaData.getCatalogs()
> and so on.
> > Squirell 2.0 is perfect example of their reproducing.
> >
> > Sincerely yours.
> > -------------------------------------------------------
> > Vitaly Zverev, OCP DBA 8&8i
> > Oracle E-Business Suite &
> > Infiniband Linux Cluster Administrator Genesis Ltd., St.Petersburg,
> > Russia
> >
>
> No, get
> http://cvs.sourceforge.net/viewcvs.py/*checkout*/freetds/freet
> ds/src/odbc/odbc.c?rev=1.396
> and
> http://cvs.sourceforge.net/viewcvs.py/*checkout*/freetds/freet
> ds/src/odbc/odbc_util.c?rev=1.70.2.2
>
> freddy77
>
>
> _______________________________________________
> FreeTDS mailing list
> FreeTDS AT lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds
>




Archive powered by MHonArc 2.6.24.

Top of Page