R – dbExpress error in Delphi 2007

dbexpressdelphidelphi-2007

I have had Delphi 2007 for a while. I tried the Delphi 2009 trial. Then I un-installed the trial. Now I get this in a dbExpress Delphi 2007 application:

---------------------------
Debugger Exception Notification
---------------------------
Project ABC.exe raised exception class TDBXError with message 
'Unable to load dbxora.dll (ErrorCode 126).  It may be missing
from the system path.'.
---------------------------
Break   Continue   Help   
---------------------------

I do not have dbxora.dll anywhere on my pc; I have dbxora30.dll, instead. Looking at another development machine (which has never had Delphi 2009 on it), I see dbxora30.dll too. FWIW, that file is here:

C:\Program Files\CodeGear\RAD Studio\5.0\bin\dbxora30.dll

And my path does include this location.

So it looks like Delphi 2009 introduced a new "dbxora.dll" which replaced "dbxora30.dll"… and when I un-installed Delphi 2009, it failed to point my system back to the original "dbxora30.dll". But now how do I use dbxora30 again?

Any suggestions?

Best Answer

I fixed the problem on my machine by editing this file:

C:\Users\Public\Documents\RAD Studio\dbExpress\dbxdrivers.ini

Under the section labeled [Oracle], I changed the "LibraryName" parameter from "dbxora.dll" to "dbxora30.dll".

I hope this helps someone else.

Related Topic