MySQL Forums
Forum List  »  Stored Procedures

Re: calling stored procedure from VBA
Posted by: Barry Galbraith
Date: June 22, 2010 04:21PM

I found that ADO couldn't call mysql SPs using the "correct" commandType = adCmdStoredProc. My method has no checking for parameter type on any parameters to the SP call

I did it like this.

Dim rs As New ADODB.Recordset
 Dim cmd As ADODB.Command
 Dim cnn As New ADODB.Connection
 
 rs.ActiveConnection = cnn

 rs.Source = "CALL myspname()"
 rs.Open

Good luck,
Barry.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: calling stored procedure from VBA
3458
June 22, 2010 04:21PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.