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 |
To set the command button for ESC, Which property needs to be changed?
which VB constant make the menu item in centre?
Explain Default cursor Type and LockEdits type in RDO
what are the types of Recordsets?
what is the Difference between Listindex and Tab index?
what is the difference between ADO and RDO in vb
What is binding? What are types of binding?
What is the difference between change event in normal combobox and dbcombobox?
What is FireHouse Cursors?
Explain about the basic features of Visual basic?
How come I get a "No Current Record" error when I use a a Data Control on an empty table?
What is the difference between c++ and visual basic?
Visual Basic (800)
C Sharp (3816)
ASP.NET (3180)
VB.NET (461)
COM+ (79)
ADO.NET (717)
IIS (369)
MTS (11)
Crystal Reports (81)
BizTalk (89)
Dot Net (2435)
Exchange Server (362)
SharePoint (720)
WCF (340)
MS Office Microsoft (6963)
LINQ Language-Integrated Query (317)
WPF (371)
TypeScript (144)
Microsoft Related AllOther (311)