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

What are some methods you can use to send data from one VB executable to another one?

2232


How can you Navigate from the DHTML application to another DHTML application? .

2182


What are the uses of List View Control?

1967


what are the Differences between Recordset and Resultsets?

2507


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

2080


how to use unicode data in vb6 regarding to telugu language, my output is in only telugu language

3582


Which property of textbox cannot be changed at runtime. What is the max size of textbox?

1017


by writing MACRO CODE,i want to retrive data from one spead sheet to another UI (workbook). control will search cell by cell for each row and load the data in another workbook(UI). ex: custdetails custname lastname locaton mobile pincode custdetails raj tony hyd 555555 521245 servcreqrd srvce# srvcename location srvcepincode servcreqrd 754 drilling hyd 521784 for the above example in the another workbook retrive data like this custname Raj srvce# 754 srvcepincode 521784. while retrieving data control will search cell by cell for each row.

2183


What is Parser Bug?

2317


How do I call a DLL?

1495


i want to retrive data from one spead sheet to another UI (workbook). control will search cell by cell for each row and load the data in another workbook(UI).

2221


How to get Cursor position using API?

2159


Explain about manipulating the recordset object

977


What is OLEDB?

2309


What are the tools available for Debuggiu in VB?

1994