Ron Kidd
asked on
Run a SQL Stored Procedure from a .vbs File and return a parameter
Hello
I need to execute a SQL Stored Procedure with a single input parameter (Integer) and return the result (Integer).
The code then needs to open a URL with the integer as a parameter ("exo://core_opportunity(x )")
I'm not sure how to connect to the database or return the parameter.
I need to run this from a .vbs file
Many Thanks
I need to execute a SQL Stored Procedure with a single input parameter (Integer) and return the result (Integer).
The code then needs to open a URL with the integer as a parameter ("exo://core_opportunity(x
I'm not sure how to connect to the database or return the parameter.
I need to run this from a .vbs file
Many Thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Line 27
ASKER
OK
I've changed line 27 to"Parameters.Append .CreateParameter("@act",5, 1)"
And "cmd" to the .execute
It now runs but the message box errors - Doesn't return the parameter.
I've changed line 27 to"Parameters.Append .CreateParameter("@act",5,
And "cmd" to the .execute
It now runs but the message box errors - Doesn't return the parameter.
ASKER
I am getting the error " Arguments are of the wrong type, are out of acceptable range or are in conflict with each other"
Below is my Code
Open in new window
Also my Stored Procedure Code
Open in new window