freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Re: [freetds] Support for SQL_SS_TIME2 / SQL_SS_TIME2_STRUCT

From: Frediano Ziglio <freddy77 AT gmail.com>
To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
Subject: Re: [freetds] Support for SQL_SS_TIME2 / SQL_SS_TIME2_STRUCT
Date: Sat, 27 Jan 2018 17:46:57 +0000

2018-01-25 13:55 GMT+00:00 Sebastien FLAESCH <sf AT 4js.com>:
> 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

[freetds] Support for SQL_SS_TIME2 / SQL_SS_TIME2_STRUCT, Sebastien FLAESCH, 01/25/2018
- Re: [freetds] Support for SQL_SS_TIME2 / SQL_SS_TIME2_STRUCT, Sebastien FLAESCH, 01/25/2018
- Re: [freetds] Support for SQL_SS_TIME2 / SQL_SS_TIME2_STRUCT, Frediano Ziglio, 01/27/2018
  - Re: [freetds] Support for SQL_SS_TIME2 / SQL_SS_TIME2_STRUCT, Sebastien FLAESCH, 01/27/2018