Re: calling stored procedure from VBA

[Barry Galbraith]

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.