[freetds] SQLSetStmtAttr - ODBC driver problem?
Nilesh Dhawale
ndhawale at gmail.com
Tue Oct 19 11:36:33 EDT 2004
> You said you're "using the array of parameters to insert a bunch of rows".
> Has that logic worked against any Sybase/Microsoft database on another
> platform? The T-SQL INSERT statement doesn't support inserting more than
> one row except from another table.
Yes, the logic has been tested with drivers for MSSQL, DB2, Redbrick,
Sybase on Windows and DB2 on AIX.
> You might try turning on TDSDUMP. It should log as errors anything not
> handled by the driver. It also might offer more details about the error.
TDSDUMP did not provide much info (but thanks for suggesting it - now
I know one more way to debug)
> > [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).
I know many drivers do not support a value more than 1; so I had even
run the appln with Value = 1 and still it had the same problem. AW,
any idea when the next release is?
Nilesh
More information about the FreeTDS
mailing list