[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