• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1574
  • Last Modified:

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,
0
FatalErr
Asked:
FatalErr
  • 4
  • 3
1 Solution
 
[ 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
 
[ fanpages ]IT Services ConsultantCommented:
Which version of WSH are you now using, and which version where you using prior to your current location?
0
The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

 
FatalErrAuthor Commented:
How can I tell what version of WSH I'm using?   I have no info about the history.
0
 
CWS (haripriya)Commented:
Replace your code with this:

.Parameters.Append .CreateParameter("FirstName", adVarChar, adParamInput, 255,variable1)
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

Featured Post

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now