VB Script on Win XP .Parameters.Append .CreateParameter("@FirstName", adVarChar, adParamInput, 255) bombs

I think something might have changed in the way VBS is interpreted by WSH or ???

The line in the question title
.Parameters.Append .CreateParameter("@FirstName", adVarChar, adParamInput, 255)
bombs with the error "arguments of the wrong type, out of range or are in conflict with each other"

Any ideas???  Thanks,
LVL 1
FatalErrAsked:
Who is Participating?
 
CWS (haripriya)Connect With a Mentor Commented:
Replace your code with this:

.Parameters.Append .CreateParameter("FirstName", adVarChar, adParamInput, 255,variable1)
0
 
[ fanpages ]IT Services ConsultantCommented:
What makes you believe this to be the case?

Have you upgraded your operating system, or version of Windows Scripting Host?

Or has the database structure changed & your parameter data type now does not match the database column?

BFN,

fp.
0
 
FatalErrAuthor Commented:
It used to run before I started working here (supposedly).  It doesn't work now and no modifications I make to it prevent the error from occuring.  That's why I suspect the WSH change.  It matches my database column.  I made a table with 1 column and edited the stored proc to have only one parameter.
0
Cloud Class® Course: Ruby Fundamentals

This course will introduce you to Ruby, as well as teach you about classes, methods, variables, data structures, loops, enumerable methods, and finishing touches.

 
[ fanpages ]IT Services ConsultantCommented:
Which version of WSH are you now using, and which version where you using prior to your current location?
0
 
FatalErrAuthor Commented:
How can I tell what version of WSH I'm using?   I have no info about the history.
0
 
[ fanpages ]IT Services ConsultantCommented:
What's "variable1"?
0
 
FatalErrAuthor Commented:
WSH (or whatever is handling this) won't evaluate the enums.  I used .Parameters.Append .CreateParameter("FirstName", 200, 3, 255) and it worked.  I went with the syntax suggestion because it was a syntax problem.  Thanks both of you for your help.  

0
 
[ fanpages ]IT Services ConsultantCommented:
Odd it worked before, and now it doesn't, in any respect.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.