INSERT Statement Being Truncated

Hello all,

I have a COM object (written in VB6) that uses the Microsoft Remote Data Object 2.0 (MSRDO20.dll) to perform non-exotic SQL statements (i.e. SELECTs, INSERTs, UPDATEs and DELETE).

I am using SQL Server 2000 with SP4.

Some of our INSERT statements are being truncated within SQL2K...

We have turned on the SQL Profiler to verify this. Using our own logging mechanism, we log the INSERT SQL being passed to SQL2K immediately before executing the MS SQL statement and our log shows that the INSERT statement is indeed correct. However, we get a SQL error back due to malformed SQL. The SQL Profiler shows that the last 10 bytes have been truncated from the INSERT SQL within SQL2K.

The INSERT statement that we are passing is in the following form...

INSERT (column names...) VALUES (...)

There are embedded CRs (0x0D) in the INSERT.
The length of the INSERT being passed to SQL2K is 2243 bytes.
The length of the INSERT from the Profiler is 2233 bytes (the last 10 bytes were truncated).

Here's a brief glimpse of our VB6 code...


Dim Cn as rdoConnection

Dim sSql as String



Set Cn = New rdoConnection

Cn.Connect = "DSN=FrontOff;UID=Front;PWD=Front;DATABASE=FrontOff;"

Cn.CursorDriver = iCursorDriver

Cn.LoginTimeout = 5

Cn.QueryTimeout = 5

Cn.EstablishConnection rdDriverNoPrompt



sSql = "INSERT INTO PLU €¦"



Cn.QueryTimeout = 300
// Log sSQL to our logging mechanism...

Cn.Execute sSql, rdExecDirect


So, is there a maximum length for a SQL statement in SQL2K???

Any help would be appreciated.

TIA!!!