Yes it is possible,the code as follows: Public myConn As New ADODB.Conne

Is it possible to call backend procedures with ADO control?

Question Posted / sarada

1 Answers
3973 Views
I also Faced
E-Mail Answers

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 Internet tools available in VB 6.0?

2874

Specify technical & functional architecture of your last 2 projects.

2118

what are the Types of cursors in RDO?

2413

What are forms in visual basic?

1098

What is snapshot in vb?

1004

Explain the "cursortype" and "Locktype" in VB?

4658

What is "Reserved Error -1209"?

2143

Explain about form creation in Visual Basic?

1335

How do I implement an incremental search in list/dir/combo/file boxes?

1461

How can Visual Basic be used for server-side scripting?

1011

Explain Types of DBCombo boxes?

1051

what are the Parts of ODBC?

1892

What is OLEDB?

2075

___ Property is used to count no. of items in a combobox.

1436

What is the use of Immediate, Local Window?

2104