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"); ***************************************************************************

近期下载者

相关文件


收藏者