newbie27
asked on
running mysql stored procedure from vbs file
Hello Experts,
I am trying to execute attached function from .vbs file but for some reason I am getting stored procedure not found error, however, when I run the same from ASP page it works fine.
Is there anything wrong with this script please advice.
Thanks
Sam
I am trying to execute attached function from .vbs file but for some reason I am getting stored procedure not found error, however, when I run the same from ASP page it works fine.
Is there anything wrong with this script please advice.
Thanks
Sam
ASKER
this is what i am getting ... please can someone advice
[MySQL][ODBC 3.51 Driver][mysqld-5.1.22-rc-c ommunity]P ROCEDURE mysql.sp_archive_folyes_da ta does not exist
[MySQL][ODBC 3.51 Driver][mysqld-5.1.22-rc-c
confirm if you are using correct connection string..
try to print this in the eport.asp code..
Response.Write (Request())
try to print this in the eport.asp code..
Response.Write (Request())
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
hello neeraj,
yes the connection string is correct as it works fine when I execute this function from the ASP page.
as you notice
wscript.echo cnObj.state ' returns 1 meaning the connection has established
yes the connection string is correct as it works fine when I execute this function from the ASP page.
as you notice
wscript.echo cnObj.state ' returns 1 meaning the connection has established
cant help much on this ..
hope some one else will resolve this issue for you quickly..
all the best
hope some one else will resolve this issue for you quickly..
all the best
ASKER
Open in new window