ROW-00054: Cannot load the library

This is an app that I haven't touched in 2 years and now they want a change.
However, when I try to run it, I get the following error:

Project xyz.exe raised exception class EOleException with message
'ROW-00054: Cannot load the library
O/S-Error: (OS 126) The specified module could not be found'. Process
stopped. Use Step or Run to continue.


This is a D7 app using Oracle. the SQL it's running looks like this:

select nvl(max(e.version),0)+1 as version
from owner.eformtbl e
where e.lnkey = :LNKEY and e.formname = :FN

All the parameters are set correctly. I get the error when I try to set the
TADOQuery.active property to true.

Like I said this has been in production for several years without issue.

I can issue the same SQL through PL/SQL developer as the same user and all
is well.



.

Relevant Pages

  • Re: Off Topic - Access to Postgres
    ... In both Jet and Oracle back ends, I always write my SQL dynamically anyway and contrary to what I think you implied in your initial response to Hank, I don't think writing Jet SQL (for Jet BE or c/s linked table approaches) nor PTQ SQL in VBA makes an app more difficult to manage or increses development time significantly. ...
    (comp.databases.ms-access)
  • Re: Oracle jdbc perf on linux and windows
    ... Since use of SQL introduces problem, I would first try to eliminate ... Oracle as the culprit. ... If it's in your app, ... TCPDUMP will help if your app is running on the same system because ...
    (comp.lang.java.programmer)
  • Re: Access vs SQL
    ... from Access, tweaked my app a bit, and viola, everything works. ... MSDE 2000 adds a bit of complexity, but I have to say, compared to ... > (above and beyond what they pay for my engineering services). ... > Now, still using C1 components, I know I can upsize to MSDE or SQL ...
    (microsoft.public.dotnet.languages.vb)
  • Re: SQl Data Provider Performance Issues
    ... Can you provide a complete sample app ... selects with a single inner join perforn OK. ... When I run the query from SQL ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: SQL Server Dual Processors INSERTS take long time
    ... Just because a server ... all you might try adding a clustered index on the table. ... Andrew J. Kelly SQL MVP ... > for other parts of the app, that need to be done in real time. ...
    (microsoft.public.sqlserver.server)