[freetds] freetds question
Jacque, Alfred
jacqual at navcanada.ca
Wed Apr 29 08:01:17 EDT 2009
Hello Freddy,
I reinstalled freetds and everything now appears to be working properly.
Thanks again for your assistance.
Alfred
-----Original Message-----
From: freetds-bounces at lists.ibiblio.org [mailto:freetds-bounces at lists.ibiblio.org] On Behalf Of Frediano Ziglio
Sent: April 29, 2009 3:28 AM
To: FreeTDS Development Group
Subject: Re: [freetds] freetds question
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
_______________________________________________
FreeTDS mailing list
FreeTDS at lists.ibiblio.org
http://lists.ibiblio.org/mailman/listinfo/freetds
More information about the FreeTDS
mailing list