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 |
To.set the command button for ESC ___ Property has to be changed.
What is Mask Edit and why it is used?
What is Tabstrip control? What is the starting Index value? How to locate it?
How many File System Controls are there Explain?
Types of LockEdits in RDO.
Which property of textbox cannot be changed at runtime?
What is controls in vb?
What is ActiveX Document?
What is datagrid in vb net?
In visual source safe if in middle of my program power was off and it was not save then wat will happen whether it will save or not? can any body tel me the answer for this.
What is ado in vb?
what component is used in vb to link to the database?