Re: freetds question
Frediano Ziglio <[email protected]>
| Newsgroups | gmane.comp.db.tds.freetds |
|---|---|
| Message-ID | <[email protected]> |
2009/4/27 Jacque, Alfred <[email protected]>: > 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 _______________________________________________ FreeTDS mailing list [email protected] http://lists.ibiblio.org/mailman/listinfo/freetds