Is it possible to call backend procedures with ADO control?
Answer Posted / sarada
Yes it is possible,the code as follows:
Public myConn As New ADODB.Connection ‘In Declaration
Section
myConn.open “DRIVER={MySQL ODBC 3.51
Driver};SERVER=127.0.0.1;Database=Db;UID=root;PWD=changeme”
myConn.CursorLocation = adUseClient
If myConn.State = ADODB.adStateOpen Then
myConn.execute “CALL sp_deleter( )“ 'Procedure calling
End If
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Is it possible to change menu runtime using API? If yes? Specify the function names.
How do I play MID, WAV or other multimedia files?
I have several megabytes of memory. Why do I get an "out of memory" error?
what are the Differences between Recordset and Resultsets?
How do you change the icon and otherwise manipulate the DOS box?
Binary Access-method isused to access file in which manner?
What is connection object in vb net?
What are 3 main differences between flexgrid control and dbgrid control?
Draw Sequence Modal of RDO? Explain.
What are the new events in textbox that has been included in VB ?
Can a VB application be an OLE server?
What is shortcut menu and explain "The ole control's shortcut menu".
Is it possible to Access BackEnd procedures?
Can you create a tabletype of recordset in Jet connected ODBC dbengine.
Difference between Linked Object and Embedded Object?