[freetds] SQL Server 2008: Support for TIME(n) data type

Sebastien FLAESCH sf at 4js.com
Fri Jan 30 11:37:54 EST 2009


OK I will give it a try, but when binding an TIMESTAMP_STRUCT
parameter that is compared to a TIME(n) column I get:

   |   sqlstate      : 42000
   |   sqlerrd2      : -402
   |   sql message   : [FreeTDS][SQL Server]The data types time and datetime are incompatible in the equal to operator.

Does anybody run some regression tests against SQL Server 2008?

I can try with SQL_C_CHAR bindings...

Seb

Frediano Ziglio wrote:
> 2009/1/30 Sebastien FLAESCH <sf at 4js.com>:
>> Thanks Frediano for the update.
>>
>> So for now we will not support SQL Server 2008 through the FreeTDS driver.
>>
>> We need support for DATE_STRUCT, TIME_STRUCT and sqlncli.h specials in
>> order to support the new SQL Server 2008 data types (date, time(n) and
>> datetime2(n)).
>>
>> Seb
>>
> 
> But sql 2008 support US :) I think you can use old protocol losing a
> bit of precision or you have to convert to other types that support
> that precision using former protocol (supported by sql 2008).
> 
> freddy77
> _______________________________________________
> FreeTDS mailing list
> FreeTDS at lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds
> 



More information about the FreeTDS mailing list