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

How do I change the color of a form in visual basic?

0 Answers  


How do I program the Novell NetWare API from VB?

0 Answers  


What is the difference among Standard EXE, Active-X DLL, Active-X EXE?

2 Answers  


what is the Default property of datacontrol ?

2 Answers  


What is ADO? What are its objects ?

1 Answers  






What are the Sequence of events when a form is loaded in Visual Basic?

6 Answers  


What are the types of API Types.

0 Answers   TCS,


What are the different cursor types that can we create using ADO Recordset? Difference between these cursor types?

2 Answers  


Is it possible to Manipulate data through flexgrid? Explain.

0 Answers  


what is the difference between ADO and RDO in vb

3 Answers  


What is instantiating?

0 Answers  


What is the difference between <F8> and <Shift-F8> when debugging?

2 Answers  


Categories