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 it possible to change menu runtime using API? If yes? Specify the function names.

2079


How do I play MID, WAV or other multimedia files?

1513


I have several megabytes of memory. Why do I get an "out of memory" error?

1573


what are the Differences between Recordset and Resultsets?

2536


How do you change the icon and otherwise manipulate the DOS box?

1502


Binary Access-method isused to access file in which manner?

1969


What is connection object in vb net?

1047


What are 3 main differences between flexgrid control and dbgrid control?

2202


Draw Sequence Modal of RDO? Explain.

2072


What are the new events in textbox that has been included in VB ?

1802


Can a VB application be an OLE server?

1417


What is shortcut menu and explain "The ole control's shortcut menu".

1066


Is it possible to Access BackEnd procedures?

2094


Can you create a tabletype of recordset in Jet connected ODBC dbengine.

1970


Difference between Linked Object and Embedded Object?

2279