[freetds] Are LOBs supported?
Sebastien FLAESCH
sf at 4js.com
Tue Jan 8 11:01:21 EST 2008
Sebastien FLAESCH wrote:
> SQLBindParameter(m_hstmt, 2, SQL_PARAM_INPUT,
> SQL_C_BINARY,
> SQL_LONGVARCHAR, 0x10000000, 0, buf2, 0,
> &vind1);
> CHECK_RCODE(SQL_HANDLE_STMT,m_hstmt,"SQLBindParameter 2");
Note that we have to bind the blob params with a large size for SQL Server
drivers, otherwise you can't insert into the database...
-> get SQLSTATE 07002 "COUNT field incorrect or syntax error" ... no idea why.
Other APIs like DB2 CLI don't need to pass a size in such case.
Don't know if this matters when using SQL_DATA_AT_EXEC with FreeTDS, but
wanted to warn you about this strange thing.
Note also that we use column-wise binding to fetch rows with:
SQL_ATTR_ROW_BIND_TYPE, SQL_BIND_BY_COLUMN
The test does not use this but our driver does, so if you fix this problem
I can continue to test with our driver code.
Thanks!
Seb
More information about the FreeTDS
mailing list