Error 3421 Please read the body for more info

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

Error 3421 Please read the body for more info

Author

Topic

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2002-05-15 : 09:54:36

Mmaphefo writes "Hi,

I'm using VB and SQL Server and always when I'm executing the statement:

Dim strSurname As ADODB.Parameter

Set strSurname = .CreateParameter("Surname", adChar, adParamInput, 20, strSurname)
.Parameters.Append strSurname

I'M GETTING THE FOLLOWING ERROR MESSAGE:

"Application uses a value of wrong type"

The data type for my field is char with the length of 20.

Thank you"

YellowBug
Aged Yak Warrior

616 Posts

Posted - 2002-05-15 : 10:27:46

Instead of
Dim strSurname As ADODB.Parameter
try
Dim strSurname As string

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources