[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