Re: ROW-00054: Cannot load the library

Found it.
Kind of...

I don't know why, but when I switched TADOQuery.LockType from ltReadOnly to
ltOptimistic it worked. Then I checged it back to ltReadOnly and it still
worked.

I thought I would update this in case anyone else sees this problem down the
line. I know there was precious little on the web about this error message
when I looked.


"Bryan Valencia" <borng.some_yahoo@xxxxxxxxxxxxxxx> wrote in message
news:4505e253@xxxxxxxxxxxxxxxxxxxxxxxxx
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

  • cannot convert between unicode and non-unicode string data types
    ... Cindy, I have the same problem, there is a solution, In the OLE DB Destination component, in the Mappings option in the input column you must choose the Data Conversion., and that's it. ... I am converting a simple (at least in the SQL Server 2000 DTS days) to this ... error message stays the same ... numerous times I have inserted the transformation task between the oracle ...
    (microsoft.public.sqlserver.dts)
  • Re: SQL Timeout Error
    ... "Robert Lakinski" wrote: ... but you can access data in Sql server via MS ... I don't know why I got the error message. ...
    (microsoft.public.sqlserver.server)
  • Re: Dup entries when creating a new DB entry (ASP Classic with an MDB file)
    ... machine and it definitely generated an error message when I left the ... initialize the strErrorMsg variable: ... I couldn't get the Parameterized querys to work to replace the SQL ... Dim strTitle ...
    (microsoft.public.inetserver.asp.db)
  • Re: cannot convert between unicode and non-unicode data types
    ... product can't actually produce a meaningful error message. ... oracle and the sql database. ... Tried dumping to a raw file but the output is still unicode when I try to ...
    (microsoft.public.sqlserver.dts)
  • Re: Multilingual versions of SQL Express 2005 available ? Where ?
    ... The error code alone is not sufficient. ... error code which is represented in the parameters used to format the SQL ... language is used. ... > we may consider provide localized error message according to the error ...
    (microsoft.public.sqlserver.setup)