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
Is visual basic easy?
What type of databases you can access through ADO Data Access Object?
How should dates be implemented so they work with other language and country formats?
Scope of API?s can be of different types, what are they Why API functions are Required?
How to use hyperlink?
___,___ arguments will be used to run a executable program in shell function
How do I create a window with a small title bar as in a floating toolbar?
How do I get the Tab key to be treated like a normal character?
What are the types of line styles available in Treeview Control?
advantage and disadvantage in visual-basic and ms-access please tell me or send my mail-id
Which type of object requires this object?
Types of LockEdits in DAO? 51 .Types of Recordsets.
How can you force new objects to be created on new threads?
How do I call help files from a VB program?
Difference between ActiveX Control and Standard Control.