ExpressODL_src
所属分类:数据库编程
开发工具:Visual C++
文件大小:92KB
下载次数:5
上传日期:2005-10-22 11:32:46
上 传 者:
etech
说明: ExpressODL_src是直接利用OLE技术的数据库封装类源码,不想用ADO,也有了选择了。
(ExpressODL_src is the direct use of the OLE technology category source database package, do not want to use ADO, also made their choices.)
文件列表:
AddrBook (0, 2002-01-22)
AddrBook\AddItemDlg.cpp (8320, 2002-01-21)
AddrBook\AddItemDlg.h (1475, 2002-01-02)
AddrBook\AddrBook.clw (1937, 2002-01-05)
AddrBook\AddrBook.cpp (1819, 2002-01-13)
AddrBook\AddrBook.dsp (7560, 2002-01-05)
AddrBook\AddrBook.dsw (583, 2002-01-02)
AddrBook\AddrBook.h (1234, 2002-01-02)
AddrBook\AddrBook.plg (1092, 2002-01-21)
AddrBook\AddrBook.rc (9225, 2002-01-02)
AddrBook\AddrBookDlg.cpp (4803, 2002-01-21)
AddrBook\AddrBookDlg.h (1629, 2002-01-13)
AddrBook\datagrid.cpp (18573, 2002-01-02)
AddrBook\datagrid.h (5127, 2002-01-02)
AddrBook\DBAccessor.h (1090, 2002-01-02)
AddrBook\res (0, 2002-01-22)
AddrBook\Resource.h (1191, 2002-01-02)
AddrBook\res\AddrBook.ico (1078, 2001-12-30)
AddrBook\res\AddrBook.rc2 (400, 2001-12-30)
AddrBook\StdAfx.cpp (210, 2001-12-30)
AddrBook\StdAfx.h (1332, 2002-01-13)
LargeText (0, 2002-01-22)
LargeText\LargeText.clw (962, 2002-01-02)
LargeText\LargeText.cpp (1529, 2002-01-02)
LargeText\LargeText.dsp (6890, 2002-01-05)
LargeText\LargeText.dsw (541, 2002-01-02)
LargeText\LargeText.h (1215, 2002-01-02)
LargeText\LargeText.plg (1673, 2002-01-22)
LargeText\LargeText.rc (4941, 2002-01-02)
LargeText\LargeTextDlg.cpp (4810, 2002-01-22)
LargeText\LargeTextDlg.h (1477, 2002-01-13)
LargeText\res (0, 2002-01-22)
LargeText\Resource.h (733, 2002-01-02)
LargeText\res\LargeText.ico (1078, 2002-01-02)
LargeText\res\LargeText.rc2 (401, 2002-01-02)
LargeText\StdAfx.cpp (211, 2002-01-02)
LargeText\StdAfx.h (1080, 2002-01-02)
QueryProc (0, 2002-01-22)
QueryProc\QueryProc.clw (1308, 2002-01-05)
QueryProc\QueryProc.cpp (1503, 2002-01-04)
... ...
========================================================================
SYPRAM'S EXPRESS OLE DB LIBRARY : SAMPLES
========================================================================
The samples provided here (in General section) illustrate the basic features
and functionalities of EXPRESS library. We have included here a Microsoft
Access database for providing sample data. So, all the samples mentioned below
use this database. However, you can connect to any database through an OLE DB
provider.
=======================================================================
INCLUDED SAMPLES
=======================================================================
ADDRBOOK :
***********
This sample shows you how you can use static and dynamic recordset classes to
manipulate data in the database. It also shows how easy it is to convert an
ODL recordset into an ADO recordset for binding it to the data-grid control.
LARGETEXT
***********
LargeText sample illustrates how simple it is to handle BLOB data using ODL
classes compared to even ADO.
QUERYPROC
***********
QueryProc sample is built to demonstrate the use of those ODL classes that
are used for executing stored procedures or parametric queries. It shows
the similarity and differences of two ODL classes : CSypODLQuery and
CSypODLCommand.
RECORDNAV
***********
This sample illustrates the basic record navigation methods and the use of
bookmarks.
TRANSENTRY
***********
TransEntry is a simple transaction-based application. It demonstrates how to
use transactions in data-centric applications.
XMLVIEW
***********
Express OLE DB library provides integrated, basic support for XML. This sample
neatly explains the ODL recordset methods used for extracting data in XML format.
=======================================================================
CONNECTING TO DIFFERENT DATABASES
=======================================================================
All the samples mentioned in the section above connect to Microsoft Access
database that is provided with the samples. The following section explains
how you can connect to other popular databases using different OLE DB providers.
Connecting to JET databases
***************************
/* m_Conn is an ODL connection object */
m_Conn.SetProvider("Microsoft.JET.OLEDB.4.0");
m_Conn.Open("DATABASE PATH", "USER ID", "PASSWORD");
Connecting to ODBC databases
***************************
/* No need to call SetProvider method, because ODBC provider is a default provider */
m_Conn.Open("ODBC_DSN", "USER ID", "PASSWORD");
Connecting to SQL Server
************************
m_Conn.SetProvider("SQLOLEDB.1");
m_Conn.Open("SERVERNAME", "USER ID", "PASSWORD", "CATALOG");
Connecting to ORACLE (Using Microsoft provider)
*********************************************
m_Conn.SetProvider("MSDAORA");
m_Conn.Open("CONNECTION_STRING", "USER ID", "PASSWORD");
***************************************************************************
近期下载者:
相关文件:
收藏者: