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)
 Pass parameters problem

Author  Topic 

TAS
Yak Posting Veteran

65 Posts

Posted - 2003-11-11 : 11:38:07
I have a store procedure with a text datatype parameter. Anybody knows how to pass text datatype parameter in ADO? I try adVarChar and adLongVarWChar.But it gives me Error: 3421.

SamC
White Water Yakist

3467 Posts

Posted - 2003-11-11 : 12:38:12
In Books OnLine, it's listed as adChar.

I wonder what length you'd specicfy in ADO? Isn't text variable length?

Go to Top of Page

robvolk
Most Valuable Yak

15732 Posts

Posted - 2003-11-11 : 12:52:53
Take a look at these:

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=28356
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=29668

Don't use adLongVarWChar unless you're passing Unicode values, use adLongVarChar instead.
Go to Top of Page
   

- Advertisement -