FreeTDS Development Group

[Sebastien FLAESCH <sf AT 4js.com>]

I believe SQL_C_TYPE_DATE / SQL_TYPE_DATE / DATE_STRUCT is not supported... 
right?

I get this error:

SQL State: HY004
Message  : [FreeTDS][SQL Server]Invalid data type

Seb


Sebastien FLAESCH wrote:
> Hi all,
>
> I was wondering if FreeTDS supports the new TIME(n) type of SQL Server 2008.
>
> I try to bind an SQL Parameter with  SQL_C_TYPE_TIME / SQL_TYPE_TIME using
> a TIME_STRUCT C structure, but I get following error:
>
>   |   sqlstate      : 42000
>   |   sqlerrd2      : -402
>   |   sql message   : [FreeTDS][SQL Server]The data types time and datetime 
> are incompatible in the equal to operator.
>
> Is this type supported and if yes do you have regression tests?
>
> It is actually a TIME(0) in the SQL Server 2008 database.
>
> Thanks a lot,
> Seb
> _______________________________________________
> FreeTDS mailing list
> FreeTDS AT lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds