all groups > sql server odbc > january 2006 >
You're in the

sql server odbc

group:

avoid an ODBC bug



avoid an ODBC bug Imre Ament
1/24/2006 6:28:03 AM
sql server odbc: Hi!

I have to manage a program what can copy data from MS Access to SQL server
(2000 and 2005).
I work with C++ and DAO 3.6.
I have a bug from the SQL server ODBC driver : "Invalid locator
de-referenced" during copy BLOB columns.
The columns bigger than 250K (I found Article ID : 245714).

I do not want to set the ODBC driver to 6.5 compatibility mode (I am afraid
other bugs will appear on the other parts of my program).
I try to update columns one by one with SQL UPDATE command but receive an
E_DAO_OutOfMemory (about 500 kbyte SQL statment).

Can anyone help me to avoid this bug (for example install specified MDAC
version)?

Regards,
Re:avoid an ODBC bug anon
2/22/2006 3:27:37 AM
I managed to avoid this bug by passing SQL_LEN_DATA_AT_EXEC(250000) as the
nullindicator to SQLBindParameter and then put the data in 250000 byte
AddThis Social Bookmark Button