[freetds] Visualisation problem

Carlo Andreoli vespito at vespito.com
Thu Dec 1 17:03:14 EST 2005


I have freetds installed in FreeBSD 4.8-STABLE.
I connect to it from Windows, using Putty or Teraterm.
Then I connect to an SQL Server:

> /usr/local/bin/odbctest "DSN=bla;UID=blabla;PWD=blabla"
iODBC Demonstration program
This program shows an interactive SQL processor
Driver: 0.63

SQL>

The problem I have is that I can't see smalldatetime columns. For instance, 
in table autor, columns dal and al are smalldatetime. I go:

SQL>select id, dal, al from autor where id=439425;

id   |
-----++
43942||

 result set 1 returned 1 rows.

Please note also that id is showed with a missing character. I have to make 
the column name longer to get it fully:

SQL>select id as idutente, dal, al from autor where id=439425;

idutente|
--------++
439425  ||

 result set 1 returned 1 rows.


Is it an easy one?
Thank you in advance for your attention. Regards;

Carlo.




More information about the FreeTDS mailing list