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

Is the Access Engine and Visual Basic Pro good enough for database work?

0 Answers  


Explain about an event-driven programming language?

0 Answers  


How do I create a new form in visual basic?

0 Answers  


What is the use of command Object?What are the various types of variables?

0 Answers  


What is OLEDB?

0 Answers  






What is the use of parameters collection?

0 Answers  


How do I get my application on top?

0 Answers  


What is DAO?

0 Answers  


What is the use of Immediate, Local Window?

1 Answers  


How would you find out the value property in Slider Bar Control?

0 Answers  


what are the Differences between ActiveX Exe and Dll?

2 Answers  


what is differece b/w Module and class Modules in vb6? thanks

4 Answers   Ask Techsys, TCS,


Categories