[freetds] freetds question
Jacque, Alfred
jacqual at navcanada.ca
Mon Apr 27 08:15:52 EDT 2009
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
-----Original Message-----
From: freetds-bounces at lists.ibiblio.org
[mailto:freetds-bounces at lists.ibiblio.org] On Behalf Of Frediano Ziglio
Sent: April 25, 2009 11:08 AM
To: FreeTDS Development Group
Subject: Re: [freetds] freetds question
2009/4/24 Jacque, Alfred <jacqual at navcanada.ca>:
> Hello,
>
>
>
> Do you have a version of freetds with 64 bit data types? I have a 64
bit
> version of an 11g database running on a 64 bit linux OS. I can connect
> to the SQL Server database, but the data is not displayed correctly.
>
>
>
> I tried using the evaluation copy from easysoft and encountered the
> exact same issue until they provided me a later version of the
software
> that included 64 bit data types. Ideally I would like to use the
freetds
> version.
>
>
>
> Thanks,
>
> Alfred
>
Mmmm.... which libraries are you using ?? dblib, ctlib or odbc? Are
you using odbc linked to Oracle? FreeTDS compile either for 32 or 64
bit... how are these uncorrect data?? Which data types??
freddy77
_______________________________________________
FreeTDS mailing list
FreeTDS at lists.ibiblio.org
http://lists.ibiblio.org/mailman/listinfo/freetds
More information about the FreeTDS
mailing list