UNIDAC

 

用过ODAC,SDAC,MyDAC,IBDAC,PgDAC(分别支持Oracle、MSSQL、MYSQL、IB/FB、 PostgreSQL)等都知道,Corelab公司的数据集驱动非常不错,取数非常快,性能稳定。Corelab的DBX驱动也是做的非常不错。相 反,Borland的DBX除了IB驱动做的可以之外,其他的DBX驱动BUG不断,尤其是oracle的驱动。但ODAC,SDAC,IBDAC这些产 品分别只能连接一种数据数据库,不仅增加了用户的消费投入,对多种数据库连接也造成诸多不便!由此,Corelab(后来改名为devart)统一了 ODAC,SDAC,MyDAC,IBDAC,PgDAC,将多种的数据库组件集成在一起,改名为UniDAC。

UniDAC由于融合了多种数据库连接,手动安装有点麻烦。虽然可以用Source目录下的Make.BAT文件,稍改一下delphi不同版本的Bin路径,但我等有点安装delphi控件经验的人,最喜欢直接用DPK文件去安装。安装步骤如下(以D7为参照):

1、找到source\delphi7目录,所有的DPK文件都在这里。

2、编译DAC 运行包,即dac70.dpk。

3、如果是D6或D7,编译DAC GUI related package,即dacvcl70.dpk。

4、编译DAC运行包,即dcldac70.dpk。

5、如果是D6或D7,编译unidacvcl70.dpk。

6、分别编译驱动包:PG/ORA/MSSQL/MYSQL/IB的驱动包。

7、编译安装UniDAC设计包,即 dclunidac70.dpk。

需要注意的是,

1、UniDAC和ODBC的驱动包有冲突。

2、UniProviders下的驱动包INC文件,诸如IbDac.inc、Odac.inc等,默认不是专业版,请在这些Inc文件中,添加一句 {$DEFINE UNIDACPRO},避免在运行期中找不到一些特定的文件。

3、DPK文件中的Option似乎有问题,最好是改为OutPut Directory改为,输出到delphi的默认路径(projects\BPL\),Unit OutPut Directory是指为".",输出到当前路径下。

4、最后一点也是老生常谈的一点,别忘给IDE的library路径添加UniDAC路径,即Source的路径。

 

Universal Data Access Components Source Code
Copyright 1997-2010, Devart. All Rights Reserved

There are two ways to compile and install UniDAC for Windows manually.

I. Using IDE

Delphi and C++ Builder for Win32
--------------------------------

Run your IDE and walk through folowing steps:
  1) Compile DAC run-time package (dacXX.dpk)
  2) Compile DAC GUI related package dacvclXX.dpk
  3) Compile DAC design-time package (dcldacXX.dpk)
  4) Compile UniDAC run-time package (unidacXX.dpk)
  5) Compile UniDAC GUI related package (unidacvclXX.dpk)
     If you are going to create CLX applications compile UniDacClx.pas unit separately.
  6) Compile and install UniDAC design-time package (dclunidacXX.dpk)
  7) Compile providers packages:
    oraproviderXX.dpk, msproviderXX.dpk, myproviderXX.dpk, ibproviderXX.dpk,
    pgproviderXX.dpk, liteproviderXX.dpk, odbcproviderXX.dpk.
    After you have compiled odbcproviderXX.dpk, compile providers that use ODBC:
    accessproviderXX.dpk, adsproviderXX.dpk, aseproviderXX.dpk, db2providerXX.dpk.

You can find these packages in
  Source\Delphi6\*.dpk - for Delphi 6
  Source\CBuilder6\*.bpk - for C++ Builder 6
  Source\Delphi7\*.dpk - for Delphi 7
  Source\Delphi9\*.dpk - for Delphi 2005
  Source\Delphi10\*.dpk - for BDS 2006
  Source\Delphi11\*.dpk - for RAD Studio 2007
  Source\Delphi12\*.dpk - for RAD Studio 2009
  Source\Delphi14\*.dpk - for RAD Studio 2010
  Source\Delphi15\*.dpk - for RAD Studio XE

To compile UniDAC based application add UniDAC Source directory path
to the "Library Path".

Delphi for .NET
-----------------

Run your IDE and walk through folowing steps:
  1) Compile DAC run-time package (Devart.Dac.dpk)
  2) Compile DAC design-time package (Devart.Dac.Design.dpk)
  3) Compile UniDAC run-time package (Devart.UniDac.dpk)
  4) Compile and install UniDAC design-time package (Devart.UniDac.Design.dpk)
  5) Compile providers packages:
    Devart.UniDac.Oracle.dpk, Devart.UniDac.SQLServer.dpk, Devart.UniDac.MySQL.dpk,
    Devart.UniDac.InterBase.dpk, Devart.UniDac.PostgreSQL.dpk,
    Devart.UniDac.SQLLite.dpk, Devart.UniDac.ODBC.dpk.
    After you have compiled Devart.UniDac.ODBC.dpk, compile providers that use ODBC:
    Devart.UniDac.Access.dpk, Devart.UniDac.Advantage.dpk, Devart.UniDac.ASE.dpk,
    Devart.UniDac.DB2.dpk.
  6) Specify the path to compiled assembles in "Assembly Search Paths"

You can find these packages in
  Source\Delphi9\*.dpk - for Delphi 2005
  Source\Delphi10\*.dpk - for BDS 2006
  Source\Delphi11\*.dpk - for RAD Studio 2007

To compile UniDAC based application add Devart.Dac and Devart.UniDac to
Namespace prefixes, add UniDAC Source directory path to the "Library Path" list.

II. Using make-files

Delphi and C++ Builder for Win32
--------------------------------

  1) Go to one of the following folders (let's denote this folder %MakePath%):
     Source\Delphi6 - for Delphi 6
     Source\CBuilder6 - for C++ Builder 6
     Source\Delphi7 - for Delphi 7
     Source\Delphi9 - for Delphi 2005
     Source\Delphi10\*.dpk - for BDS 2006
     Source\Delphi11\*.dpk - for RAD Studio 2007
     Source\Delphi12\*.dpk - for RAD Studio 2009
     Source\Delphi14\*.dpk - for RAD Studio 2010
     Source\Delphi15\*.dpk - for RAD Studio XE

  2) Find in the 'Make.bat' line containing

     set IdeDir="D:\Program Files\Borland\Delphi7

     and make sure that correct path to IDE is set (always include forward
     quote and do not include ending quote)

  3) Run 'Make.bat'. Binaries will be copied to %MakePath%\UniDac subfolder
  4) Copy %MakePath%\UniDac\*.bpl files to a folder that is included in the
     PATH environment variable
  5) Run IDE and add dclunidacXX.bpl via Component->Install Packages... menu
  6) To compile UniDAC based application add UniDAC Source directory path
     to the "Library Path" list

Delphi for .NET
-----------------

  1) Go to the following folders (let's denote this folder %MakePath%):
     Source\Delphi9\*.dpk - for Delphi 2005
     Source\Delphi10\*.dpk - for BDS 2006
     Source\Delphi11\*.dpk - for RAD Studio 2007

  2) Find in the 'Make.bat' line containing

     set IdeDir="D:\Program Files\Borland\BDS\4.0

     and make sure that correct path to IDE is set (always include forward
     quote and do not include ending quote)

  3) Run 'Make.bat'. Binaries will be copied to %MakePath%\UniDac subfolder
  4) Run IDE and add Devart.UniDac.Design.dll via Component->Installed
     .NET Components->.NET VCL Components->Add... menu. Specify the path to compiled assembles
     in Component->Assembly Search Paths->Add... menu

  6) To compile UniDAC based application add Devart.Dac and Devart.UniDac to
     Tools->Options->Environment Options->Delphi Options->Library->
     Namespace prefixes

 

转载于:https://www.cnblogs.com/zerovirs/archive/2012/01/28/2330310.html

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
Product Description Universal Data Access Components (UniDAC) is a library of components that provides direct access to most popular database servers from Delphi, Delphi for .NET and, C++Builder. UniDAC can work with such servers as Oracle, Microsoft SQL Server, MySQL, Interbase, Firebird. The UniDAC library is designed to help programmers develop faster and cleaner cross-database applications. UniDAC is a complete replacement for such standard universal technology as dbExpress. UniDAC is a handy in use and efficient data access solution bringing into play many features specific to each server. Requirements UniDAC is a product joining functionality of such data access solutions as ODAC, SDAC, MyDAC, and IBDAC. Requirements of UniDAC depend only on used providers. Detailed requirements for each provider can be found in the Requirements topic in the UniDAC Help documentation. Installation Compiled versions of UniDAC are installed automatically by the UniDAC Installer for all supported IDEs. Versions of UniDAC with Source Code must be installed manually. For more information, see the Installation topic of the UniDAC Help documentation. It is important to know that UniDAC, ODAC, SDAC, MyDAC, and IBDAC use the common base packages, so product compatibility is provided for the current build only. In the other words, if you upgrade one of the installed providers, it may conflict with older builds of other products. In order to continue using the products simultaneously, you should upgrade all of them at the same time. 7.1.4 29-Sep-17 InterBase data provider Bug with the "Input parameter mismatch" error for procedure is fixed Bug with transactions when working with Firebird 2.5 is fixed 7.1.3 19-Sep-17 The performance of TVirtualQuery is significantly improved Application-defined functions in TVirtualQuery are supported Application-defined collations in TVirtualQuery are supported AutoInc fields in TVirtualTable are supported Bug with assertion failure when updating a record in TVirtualQuery is fixed Bug with compatibility with TkbmMemTable in TVirtualQuery is fixed Bug with complex WHERE clauses that have several string fields in TVirtualQuery is fixed Bug with selecting from a dataset with a single record in TVirtualQuery is fixed Bug with generating SQL for batch updates is fixed Bug with the Locate method for non-Windows platforms in Lazarus is fixed Bug with the FindFirst, FindLast, FindNext, FindPrior methods in Lazarus is fixed Bug with accessing a product help from the IDE menu is fixed Bug with recreating fields when calling Open after Prepare is fixed Bug with an incorrect error message when using the Connect dialog component on mobile platforms is fixed Bug with AV failure when using calculated fields in TClientDataset is fixed Bug with a key violation error when executing batch operations is fixed Bug with Assert when calling the Locate method in the SmartFetch mode is fixed Bug with using DAC components in DataModule for Linux is fixed Cloud data providers BigCommerce provider is added Dynamics CRM provider is added FreshBooks provider is added Magento provider is added MailChimp provider is added NetSuite provider is added QuickBooks provider is added Salesforce provider is added Salesforce Marketing Cloud provider is added SugarCRM provider is added Zoho CRM provider is added Oracle data provider Oracle 12c connection modes (SYSBACKUP, SYSDG, SYSKM) in the Direct mode are supported OS authentication in the Direct mode is supported NChar literal replacement is supported CLOB parameters behavior when UnicodeEnvironment=True is improved Bug with lost chars in a parameter value when ConvertEOL=True is fixed SQLServer data provider Bug with processing varchar fields when AutoTranslate is True in the Direct mode is fixed Bug with processing a field with alias for query with the JOIN statement is fixed Bug with date and time fractional seconds precision when DescribeParams = True is fixed MySQL data provider Azure Database for MySQL is supported JSON data type is supported InterBase data provider Support for Firebird on Android platform is added Support for Firebird 3 packages is added Aliases handling in the RETURNING clause is supported The WireCompression connection parameter for Firebird 3 is supported Bug with using BLOB data type in batch operations is fixed Bug with the OnBackupProgress event handler in TUniDADump is fixed Bug with using batch parameters of the Bytes type is fixed Bug with closing a connection that has an active transaction for Firebird 3 is fixed Bug with recreating a connection on Linux and mobile platforms is fixed PostgreSQL data provider SSPI authentication is supported Processing GUID data type for the TGuidField class is improved SQLite data provider Now the Direct mode is based on the SQLite engine version 3.20.0 Custom SQL aggregate functions are supported Bug with opening an existing database on iOS 64 is fixed Bug with detecting field types is fixed Bug with international symbols in non-Unicode Delphi versions is fixed Bug with low performance of the LoadFromDataSet method of the Loader component is fixed Bug with index backup using the Dump component when the TableNames property is set is fixed DBF data provider The CodePage specific options are added The ConnectMode specific options are added Bug with using CDX indexes is fixed DB2 data provider The DECFLOAT data type is supported 7.0.2 15-May-17 Bug with using TVirtualQuery with TVirtualTable is fixed Bug with processing NULL values in the Loader component is fixed Bug with executing a query after executing a batch command is fixed Bug with executing a batch operation inside an explicitly started transaction is fixed Bug with using the AsGuid property is fixed Oracle data provider Bug with authentication in the Direct mode is fixed MySQL data provider Bug with processing DATETIME fields is fixed SQLServer data provider Bug with the "Invalid column name" error when editing a query with the JOIN statement is fixed InterBase data provider Bug with memory leak when using the SQLMonitor component is fixed PostgreSQL data provider Bug with AV failure after executing the Ping method is fixed SQLite data provider Bug with creating a database in the Direct Mode on Android is fixed

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值