FreeTDS Development Group

[Frediano Ziglio <freddy77 AT gmail.com>]

2009/4/27 Jacque, Alfred <jacqual AT navcanada.ca>:
> Hello,
>
>
>
> Thanks for your response. I will try and provide you with more
> information regarding this problem.
>
>
>
> -     I am using odbc.
>
> -     I have installed the latest version of unixODBC.
>
>
>
> Below is an example of where the problem that I am encountering:
>
>
>
>
>
> Freetds odbc driver:
>
>
>
> select * from postal_type@mssql;
>
>
>
> Postal_Type_Code     Postal_Type_Desc_E   Postal_Type_Desc_F   Effective
> Expiry_Da Last_Upda
>
> -------------------- -------------------- -------------------- ---------
> --------- ---------
>
>                     Unknown              Inconnue             22-FEB-08
> 22-FEB-08
>
> M                    Unknown              Inconnue             22-FEB-08
> 22-FEB-08
>
>                                                               22-FEB-08
> 00-DECEMB 22-FEB-08
>
>                                                               22-FEB-08
> 00-DECEMB 22-FEB-08
>
>
>
> Easysoft ODBC Driver:
>
>
>
> select * from postal_type@mssql;
>
>
>
> POSTAL_TYPE_CODE     POSTAL_TYPE_DESC_E   POSTAL_TYPE_DESC_F   EFFECTIVE
> EXPIRY_DA LAST_UPDA
>
> -------------------- -------------------- -------------------- ---------
> --------- ---------
>
>                     Unknown              Inconnue             22-FEB-08
> 22-FEB-08
>
> M                    Unknown              Inconnue             22-FEB-08
> 22-FEB-08
>
> P                    Unknown              Inconnue             22-FEB-08
> 22-FEB-08
>
> U                    Unknown              Inconnue             22-FEB-08
> 22-FEB-08
>
>
>
>
>
>
>
> Thanks,
>
> Alfred
>

So... first row is ok, following seems not correct... I think it would
be better to enable unixODBC trace, you can enable it adding to
/etc/odbcinst.ini some rows like. Obvously every unixODBC activity are
traced so don't use in production to avoid slowing down all queries.

[ODBC]
Trace           = Yes
TraceFile               = /tmp/sql.log

freddy77