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

What are the uses of List View Control?

1656


What is instantiating?

1947


What is the use of ActiveX Documents?

2187


What is the Windows API?

1212


Difference between Recordset and Resultsets.

3804


What is difference between datagrid and flexgrid?

13111


what is the control used to call a windows application.

1695


1s it posible to Create Tables Through Querydef?

1893


What is rdo in vb?

725


How do I program the Novell NetWare API from VB?

1189


Parts of ODBC?

1650


How would you create your application in DHTML?

1705


___ VB constant make the menu item in centre.

1543


what are the Types of LockEdits in RDO?

1802


What is the use of property page Wizard in ActiveX Control?

2212