FreeTDS Development Group

[Зверев Виталий Борисович <VZverev AT genesis.spb.ru>]

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
>