Runtime Error 3421

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Kris - 30 Sep 2003 13:50 GMT

I have an application that is getting a random run-time
error 3421. According to the knowledge base, this is
related to passing a BLOB argument to a stored procedure
(Q190450). While my application uses a stored procedure,
there are no BLOB arguments. I have checked the data types
for the stored procedure and the code calling the stored
procedure. They are identical. Any ideas?

Reply to this Message

Richard J - 30 Sep 2003 15:23 GMT

Error 3421: Data type conversion error (if I remember
correctly).

Question: are you using SQL Server or Access? And if you
are using SQL Server, what version?

SQL Server 6.5 and earlier do not allow implicit
conversions ... meaning you can't pass an integer into
your stored procedure if the field is defined as a text
field, and vice versa.

One idea would be to pull the SQL statement out of your
stored procedure (just for testing mind you) and put it
inline into your application. This will eliminate any
question as to it being a problem with the SQL statement
or not.

But I would start with verifying that the data type you
are declaring in your stored procedure equates to the data
type of the corresponding field(s) in your database.

>-----Original Message-----
>I have an application that is getting a random run-time
[quoted text clipped - 5 lines]
>procedure. They are identical. Any ideas?
>.

Reply to this Message

VB Forum / Database Access / September 2003

Runtime Error 3421