ODBC Error

  • Using TCL code I can make a connection to SQL Server. I can even insert a row into a table in SQL server. The insert statement is inserting the entire contents of a text file right into a ntext column in the table. This process works fine for files < 32K in size. The process fails for files > 32K and less than 300K. I believe the problem is with the ODBC driver cause I get a memory error in my Tcl program (see below) Anyone dealt with this problem before ?

    Title: Hciengine.exe - Application Error

    The instruction at "0x77fcb7ee" referenced memory at "0x6f6d20de". The memory could not be "written". Click on OK to terminate the program. The OK button is my only option.

    Thank you.

  • I don't know of any limitation in the driver, though there may be. In earlier iterations of ADO/DAO it was necessary to "chunk" the data, ADO streams do away with that (though may still do it behind the scenes). Im guessing you're using neither of the two though?

    Andy

    http://www.sqlservercentral.com/columnists/awarren/

  • I get this error even if a I do use a parameter marker with a while loop and the SQLPutData command to chunk the data. I have not tried the ADO stream. Honestly, I don't know if I can use ADO with my TCL code cause the TCL code is a feature of another program.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply