Skip to Content.
Sympa Menu

freetds - RE: [freetds] SQLSetStmtAttr - ODBC driver problem?

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "ZIGLIO, Frediano, VF-IT" <Frediano.Ziglio AT vodafone.com>
  • To: "Nilesh Dhawale" <ndhawale AT gmail.com>, "FreeTDS Development Group" <freetds AT lists.ibiblio.org>
  • Cc:
  • Subject: RE: [freetds] SQLSetStmtAttr - ODBC driver problem?
  • Date: Tue, 19 Oct 2004 08:56:08 +0200

>
> Hi all,
>
> I am using the array of parameters to insert a bunch of rows in a
> Sybase DB using freeTDS odbc driver. It seems that only 1 row gets
> written everytime immaterial of the number of rows input. I have a
> feeling that may be some thing is not quitre right with the
> SQLSetStmtAttr function in the odbc driver. The documentation just
> mentions "partial support" for this functions but does not say what
> attributes are supported and which ones are not. Can someone tell me
> from the trace below if there is anything that is not supported and I
> am using? (I have run my code on a lot of databases on other platforms
> so I am pretty confident that it is not a code problem). Note in the
> trace that all the SQLSetStmtAttr calls return SQL_SUCCESS still
> SQLGetDiagField returns SQL_ERROR:
>
> [ODBC][28308][SQLSetStmtAttr.c][236]
> Entry:
> Statement = 37578
> Attribute = SQL_ATTR_PARAMSET_SIZE
> Value = 2
> StrLen = 0
> [ODBC][28308][SQLSetStmtAttr.c][685]
> Exit:[SQL_SUCCESS]

You are using 0.62. Current CVS (0.63) correctly returns SQL_ERROR if
Value != 1. I'm not going to patch 0.62 anymore (I don't have much time
to do it and 0.63 it's quite ready).

freddy77




Archive powered by MHonArc 2.6.24.

Top of Page