[freetds] freetds question
Frediano Ziglio
freddy77 at gmail.com
Wed Apr 29 03:28:05 EDT 2009
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 at 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 at 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
More information about the FreeTDS
mailing list