Any difference in speed / functionality to ODAC?

Discussion of open issues, suggestions and bugs regarding UniDAC (Universal Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
Moehre
Posts: 42
Joined: Fri 11 Nov 2005 11:37

Any difference in speed / functionality to ODAC?

Post by Moehre » Sat 08 Feb 2014 06:31

Hi,

Most of our customers are using oracle databases, so we bought your ODAC tools to access them, which works fast and fine ;) For some reasons we had to build software connecting with SQLServer too, so we bought your UniDAC tools and this also is working as expected.

Unfortunately I often have problems to install UniDAC und ODAC on the same system because of differences in the bpl's used. So I'm considering to use UniDAC as the "one-and-only" database tool.

Are there any disadvantages using UniDAC -> Oracle compared to ODAC? (Speed, package sizes)

BTW: Is it possible to get information about compatibility of ODAC / UniDAC versions? (f.e. which UniDAC version (if any) would be installable with the ODAC 9.2.5 version?)

Thx
Detlev

AlexP
Devart Team
Posts: 5530
Joined: Tue 10 Aug 2010 11:35

Re: Any difference in speed / functionality to ODAC?

Post by AlexP » Mon 10 Feb 2014 15:05

Hello,

For simultaneous work of several DAC products, their versions must be compatible, since all the DAC products use the same basic libraries. We can send you an ODAC trial compatible with your UniDAC version.
UniDAC is universal data access components for various databases. In UniDAC, you can work with both Oracle and MS SQL servers, however, in contrast to the other DAC products, server-specific features of a particular database are not implemented in UniDAC.
Since UniDAC uses the same classes as ODAC, then UniDAC and ODAC have no difference in performance.
ODAC 9.2.5 is compatible with UniDAC 5.2.5

Moehre
Posts: 42
Joined: Fri 11 Nov 2005 11:37

Re: Any difference in speed / functionality to ODAC?

Post by Moehre » Wed 12 Feb 2014 16:06

Thx for your answer, unfortunately I can not run UniDAC 5.2.5 with my ODAC 9.2.5; on startup of Delphi XE5 an error "Unable to load package dclunidac190.bpl" because of a missing procedure entry point in dcldac190.bpl arises

Maybe it has something to do with the "never" ODAC Version I am using where the ORA-1440 error is solved?

Greetings
Detlev

AlexP
Devart Team
Posts: 5530
Joined: Tue 10 Aug 2010 11:35

Re: Any difference in speed / functionality to ODAC?

Post by AlexP » Wed 12 Feb 2014 16:34

Yes, this problem can be due to the fact that you are using a release build of UniDAC and a night build of ODAC.

Post Reply