[freetds] SQLSetStmtAttr - ODBC driver problem?
ZIGLIO, Frediano, VF-IT
Frediano.Ziglio at vodafone.com
Tue Oct 19 02:56:08 EDT 2004
>
> 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
More information about the FreeTDS
mailing list