I have a stored procedure in a SQL Server 7 database that takes a parameter
of type "text" to insert into a text field in my database.
My problem is, what data type (adVarchar, adInteger etc) to use when
creating the parameter object in VBScript.
set prmTest = cmdTest.CreateParameter("Description", adXXXXXXXX,
adParamInput, 0, sDescription)
What constant should I use for adXXXXXXX?
I have tried all the obvious ones (adBSTR, adVarChar etc) but only get error
messages telling me they are the wrong type :(
Thanks in advance