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
What are some methods you can use to send data from one VB executable to another one?
How can you Navigate from the DHTML application to another DHTML application? .
What are the uses of List View Control?
what are the Differences between Recordset and Resultsets?
What type of databases you can access through ADO Data Access Object?
how to use unicode data in vb6 regarding to telugu language, my output is in only telugu language
Which property of textbox cannot be changed at runtime. What is the max size of textbox?
by writing MACRO CODE,i want to retrive data from one spead sheet to another UI (workbook). control will search cell by cell for each row and load the data in another workbook(UI). ex: custdetails custname lastname locaton mobile pincode custdetails raj tony hyd 555555 521245 servcreqrd srvce# srvcename location srvcepincode servcreqrd 754 drilling hyd 521784 for the above example in the another workbook retrive data like this custname Raj srvce# 754 srvcepincode 521784. while retrieving data control will search cell by cell for each row.
What is Parser Bug?
How do I call a DLL?
i want to retrive data from one spead sheet to another UI (workbook). control will search cell by cell for each row and load the data in another workbook(UI).
How to get Cursor position using API?
Explain about manipulating the recordset object
What is OLEDB?
What are the tools available for Debuggiu in VB?