[prev in list] [next in list] [prev in thread] [next in thread] 

List:       freetds
Subject:    Re: [freetds] Squirrel JDBC-ODBC Bridge and freeTDS ODBC
From:       "ZIGLIO, Frediano, VF-IT" <Frediano.Ziglio () vodafone ! com>
Date:       2005-11-08 8:50:34
Message-ID: F7F148C986A2A84F930FEB8C3B169EA002FBC333 () OPDMEXO01 ! omnitel ! it
[Download RAW message or body]

 
> 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
> 

I would prefer a real fix not a workaround. change_database accept a
unquoted "catalog" name not a quoted one.

freddy77
_______________________________________________
FreeTDS mailing list
FreeTDS@lists.ibiblio.org
http://lists.ibiblio.org/mailman/listinfo/freetds
[prev in list] [next in list] [prev in thread] [next in thread]