text row in SQL Server 7...

How can I use ADO to pass large amounts of data to a stored procedure?

[GaryK]

This question is for Classic ASP.

I have a column in a SQL Server 7 table that's of datatype text because I need to store up to 32KB of data in it.

I use a .dll file created in VB6 to call the stored procedure via ADO. When I define my Cmd.Parameters.Append Cmd.CreateParameter parameter for the row in question I don't know what datatype to use so it will be compatible with the text datatype in SQL Server.

I've spent the last two-plus hours searching Google for help, including limiting searches to WW but everything I've tried has failed.

Surely there's a way to pass large amounts of string data to a SQL Server sproc via VB6 and ADO?

Thanks in advance for any help you all can offer me. :)

[martyt]

Search at groups.google.com and you'll find plenty of information.

[groups.google.com...]

[GaryK]

Thanks, martyt. I found exactly what I was looking for and now my stored procedure is happily cooperating with ADO.

If anyone else runs across this problem sticky me and I'll provide some working code snippets. It's really much easier than I thought it would be. Which means it's nice to have helpful people like martyt, and a good night's sleep. :)