MS SQL Server ODBC - [Microsoft][ODBC SQL Server Driver][SQL Server]282

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

[Microsoft][ODBC SQL Server Driver][SQL Server]282

Jenney

2006-02-16, 3:23 am

We have a client machine that is running a VB application (VB6). The VB app
will use ADO 2.8 to call into a SQL Server running on another machine.

When calling into SQL SERVER, the VB will invoke a stored procedure, passing
to it a 200K string which is a string. The content of the string is an XML
text.

The SP did parse the string, and did save its content into database.

However, we get this exception (error message) in VB. The value of
Err.Description is -

[Microsoft][ODBC SQL Server Driver][SQL Server]282

When we check the code, we believe it is likely one of these two statement
caused the error message -
cmd.Execute
lRet = cmd("return")

We searched among internet and Microsoft Knowledge Base. Unfortunately we
cannot find any info for this error message. The error message itself is not
very helpful as to indicating why the driver is not happy.

Please help.

Thanks.

Sponsored Links