Database Programming
Acronyms & Abbreviations
Adjectives and Articles
Pronouns

What is full form of ADODB?

User Avatar
Wiki User
2007-07-05 06:29:57

ADODB = ActiveX Data Objects for Data Base. The ADODB is

collection of methods to access the data from the database for

Applications developed using Microsoft Visual Studio. Example:

Taken from Microsoft's MSDN-Oct-2005

CLEAR

LOCAL oConn as "adodb.connection"

LOCAL oRS as "adodb.recordset"

oConn = CREATEOBJECT('adodb.connection')

oRS = CREATEOBJECT('adodb.recordset')

cConnStrng = ;

"Provider=vfpoledb;Data

Source="+HOME(2)+"Northwind\Northwind.dbc"

oConn.Open(cConnStrng)

oConn.BeginTrans()

oConn.Execute("UPDATE Customers SET contactname = 'Patricio X.

Simpson';

WHERE customerid='CACTU'")

oRS = oConn.Execute("SELECT * FROM customers WHERE customerid =

'CACTU'")

?oRS.Fields("contactname").Value

oConn.RollbackTrans()

oRS.Requery()

?oRS.Fields('contactname').Value

oRS.Close()

oConn.Close()


Copyright © 2020 Multiply Media, LLC. All Rights Reserved. The material on this site can not be reproduced, distributed, transmitted, cached or otherwise used, except with prior written permission of Multiply.