Skip to Content.
Sympa Menu

freetds - Re: [freetds] Support for SQL_SS_TIME2 / SQL_SS_TIME2_STRUCT

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Sebastien FLAESCH <sf AT 4js.com>
  • To: freetds AT lists.ibiblio.org
  • Subject: Re: [freetds] Support for SQL_SS_TIME2 / SQL_SS_TIME2_STRUCT
  • Date: Thu, 25 Jan 2018 16:41:47 +0100

FYI I am using the binding params as described here:

https://docs.microsoft.com/en-us/sql/relational-databases/native-client-odbc-how-to/use-date-and-time-types

Seb

On 01/25/2018 02:55 PM, Sebastien FLAESCH wrote:
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
_______________________________________________
FreeTDS mailing list
FreeTDS AT lists.ibiblio.org
https://lists.ibiblio.org/mailman/listinfo/freetds






Archive powered by MHonArc 2.6.24.

Top of Page