Is it possible to call backend procedures with ADO control?



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

Post New Answer

More Visual Basic Interview Questions

To.set the command button for ESC ___ Property has to be changed.

0 Answers  


What is Mask Edit and why it is used?

0 Answers  


What is Tabstrip control? What is the starting Index value? How to locate it?

1 Answers  


How many File System Controls are there Explain?

0 Answers  


Types of LockEdits in RDO.

0 Answers  






Which property of textbox cannot be changed at runtime?

1 Answers  


What is controls in vb?

0 Answers  


What is ActiveX Document?

1 Answers  


What is datagrid in vb net?

0 Answers  


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.

8 Answers   Wipro,


What is ado in vb?

0 Answers  


what component is used in vb to link to the database?

2 Answers   Satyam,


Categories