Is it possible to call backend procedures with ADO control?

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

How do I force a file dialogue box to reread the currect disk?

1046


What language does visual basic use?

605


What is snapshot in vb?

626


Is there any Edit method in ADO Data Access method?

1613


How would you create properties by using class Builder Wizard?

2192






How would you create Visual basic Document file?

2005


How would you navigate between one document to another document

1273


How would you create properties in ActiveX Control?

1617


What is ado in vb.net?

610


Explain about an event-driven programming language?

624


How about Access 2.0 compatibility?

1104


What is meant by Establish Connection in RDO?

1927


It is possible to access Text (x.txt) files? Explain.

1641


Why visual basic is used?

638


Can any one please suggest which institute is providing Advance Excel & VBA Macros in Excel training in Hyderabad.

1825