Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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

Is visual basic easy?

962


What type of databases you can access through ADO Data Access Object?

2041


How should dates be implemented so they work with other language and country formats?

1346


Scope of API?s can be of different types, what are they Why API functions are Required?

1886


How to use hyperlink?

963


___,___ arguments will be used to run a executable program in shell function

1716


How do I create a window with a small title bar as in a floating toolbar?

1285


How do I get the Tab key to be treated like a normal character?

1411


What are the types of line styles available in Treeview Control?

1835


advantage and disadvantage in visual-basic and ms-access please tell me or send my mail-id

3080


Which type of object requires this object?

1929


Types of LockEdits in DAO? 51 .Types of Recordsets.

1832


How can you force new objects to be created on new threads?

2291


How do I call help files from a VB program?

1368


Difference between ActiveX Control and Standard Control.

2569