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

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
0
newbie27
Asked:
newbie27
  • 3
  • 3
1 Solution
 
newbie27Author Commented:

Function archivefolyesData()
 
    Set cObj= CreateObject("ADODB.Command")
    cObj.ActiveConnection = cnObj
	wscript.echo cnObj.state ' returns 1 
    msgbox adCmdStoredProc ' returns 4 
    cObj.CommandText = "sp_archive_folyes_data"
    cObj.CommandType = 4
     
    cObj.Execute
    
    If err.number <> 0 then
        archivefolyesData = err.Description 
    Else
        archivefolyesData = "OK"    
    End If
    
    Set cObj = Nothing     
End Function

Open in new window

0
 
newbie27Author Commented:
this is what i am getting ... please can someone advice
[MySQL][ODBC 3.51 Driver][mysqld-5.1.22-rc-community]PROCEDURE mysql.sp_archive_folyes_data does not exist
0
 
neeraj523Commented:
confirm if you are using correct connection string..

try to print this in the eport.asp code..

Response.Write (Request())
0
Restore individual SQL databases with ease

Veeam Explorer for Microsoft SQL Server delivers an easy-to-use, wizard-driven interface for restoring your databases from a backup. No expert SQL background required. Web interface provides a complete view of all available SQL databases to simplify the recovery of lost database

 
neeraj523Commented:
ignore these lines in my last post

'try to print this in the eport.asp code..

Response.Write (Request())'

posted at wrong question :)
0
 
newbie27Author Commented:
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
0
 
neeraj523Commented:
cant help much on this ..

hope some one else will resolve this issue for you quickly..

all the best
0

Featured Post

Transaction-level recovery for Oracle database

Veeam Explore for Oracle delivers low RTOs and RPOs with agentless transaction log backup and transaction-level recovery of Oracle databases. You can restore the database to a precise point in time, even to a specific transaction.

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