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 forms in visual basic?
Can you tell me the properties of the controls?
What is DBSqlPassThrough?
To.set the command button for ESC ___ Property has to be changed.
___ argument can be used to make a menuitem into bold.
which property is used to change to some value to access a identity column in datacontrols?
What is form in visual basic?
How do I change the color of a form in visual basic?
Write the steps in Creating ActiveX Dll and Active Exe?
What is meant by Establish Connection in RDO?
Write the steps in Creating ActiveX Dll and Active Exe?
What is Parser Bug?
What is the use of command Object?What are the various types of variables?
What is the default workspace?
What is meant by Establish Connection in RDO?