Is it possible to call backend procedures with ADO control?
Answer / 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 |
How do I change the color of a form in visual basic?
How do I program the Novell NetWare API from VB?
What is the difference among Standard EXE, Active-X DLL, Active-X EXE?
what is the Default property of datacontrol ?
What is ADO? What are its objects ?
What are the Sequence of events when a form is loaded in Visual Basic?
What are the types of API Types.
What are the different cursor types that can we create using ADO Recordset? Difference between these cursor types?
Is it possible to Manipulate data through flexgrid? Explain.
what is the difference between ADO and RDO in vb
What is instantiating?
What is the difference between <F8> and <Shift-F8> when debugging?