FreeTDS Development Group

["ZIGLIO, Frediano, VF-IT" <Frediano.Ziglio AT vodafone.com>]

> 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