Column types reported from SQL Server 1008

Steve Teale <[email protected]>
Newsgroups gmane.comp.db.tds.freetds
Message-ID <1321610294.1857.18.camel@ACER>
I have test table 'basetest' in SQLExpress 2008 that has a variety of
columns for test purposes. I created it in MS Server Management Studio.

I have 2 columns that the SMS shows as bigint, a time(7) column, and a
date column among others.

I created a single row using SMS.

I connect to the server, and use SQLExecuteDirect to do "select * from
dbo.basetest". Then using the same statement handle, I call
SQLDescribeCol() and SQLColAttribute() for SQL_DESC_TYPE_NAME.

The type for the bigint columns comes back as 8 (SQL_DOUBLE), and the
type name correspondingly as 'float'. The time and date columns are
reported as 12 (SQL_VARCHAR) and 'varchar'.

All the other reported types and names make sense.

My freetds.conf file has the protocol version as 8.0.

What am I missing?

Steve
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.