Re: calling stored procedure from VBA
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.
Subject
Views
Written By
Posted
9652
June 22, 2010 12:37PM
3580
June 22, 2010 02:48PM
2769
June 22, 2010 03:29PM
3720
June 22, 2010 03:42PM
2774
June 22, 2010 04:20PM
2494
June 22, 2010 04:46PM
Re: calling stored procedure from VBA
3458
June 22, 2010 04:21PM
2382
June 22, 2010 04:41PM
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.