Re: Support for SQL_SS_TIME2 / SQL_SS_TIME2_STRUCT

Frediano Ziglio <[email protected]> Sat, 27 Jan 2018 17:46:57 +0000

Newsgroups	gmane.comp.db.tds.freetds
Message-ID	<CAHt6W4d1yjw-wRH_WDLbV7ZZ5sFDqx-nTL6udOrQjSF+Vo2ckg@mail.gmail.com>

2018-01-25 13:55 GMT+00:00 Sebastien FLAESCH <[email protected]>:
> Hi all,
>
> I need to know what is the status of SQL_SS_TIME2 / SQL_SS_TIME2_STRUCT
> support in 1.00
>
> I am using 1.00.15 for now.
>
> When binding an SQL Parameter with this structure to insert a TIME(N) value,
> I get the following error:
>
> SQLState = HY003
> Message  = [FreeTDS][SQL Server]Program type out of range
>
> Is this structure/type properly supported?
>
> Where can I find some code example?
>
> What needs to be set in the C type, precision and scale in
> SQLBindParameter() ?
>
> Thanks!
> Seb

Hi,
  I though was implemented!

But I just tested master and is not.
Weird... there's some handling for SQL_SS_TIME2 from C to TDS but then
the conversion fails as the conversion is not available in libTDS!

Frediano