Re: Error Cannot Load Resource File sqresus.dll

"Ivan Cheng" <piucheng_at_hotmail.com> wrote in message news:<zOvZ6.550532$166.11420550_at_news1.rdc1.bc.home.com>...
> Hi Andy,
>
> "... moved the sqresus.dll from c:\oracle\ora81\bin to c:\winnt\system32 and
> it resolved the error.
> ... know that doesn't completely answer the question for 95 users, but might
> help. "
>
> source: http://www.orafaq.com/msgboard/windows/messages/409.htm

If this actually solved the problem, it would strongly imply that the %ORACLE_HOME% directory wasn't in the machine's path. Most of the time 1114 errors are caused by this and should be fixed by adding the directory to your path.

Justin Cave

>
> "Andy Hallam" <ahm_at_exel.co.uk> wrote in message
> news:9gak82$o9q$1_at_reader-00.news.insnet.cw.net...
> > Hello all.
> >
> > OS=WINDOWS2000
> >
> > Currenctly my C++ applications communicate with a SQL SERVER2000 DB
 through
> > ODBC.
> >
> > I am now porting our applications to connect to an ORACLE DB.
> >
> > I have a standalone APP that uses the following connection string through
> > SQLDriverConnect() :-
> > "DRIVER={Oracle ODBC Driver}; UID=System; PWD=Manager; DBQ=EFACS;"
> > This works fine.
> >
> > When I compile the connection code into a DLL and run my APP I get the
> > "Error Cannot Load Resource File sqresus.dll", querying the ODBC errors
> > collect using SQLGetDiagRec() I get the following :-
> > "-160 : Specified driver could not be loaded due to system error 1114
> > (Oracle ODBC Driver)."
> >
> > Looking at the OraOLEDB Readme file there is the following with reference
 to
> > C++ :-
> > Microsoft Visual C++ 6.0 Notes
> > ==============================
> > OraOLEDB.h must be included in the relevant .cpp files in the VC++
> > project. Also, #define DBINITCONSTANTS needs to be added to one of
> > the .cpp files in the project.
> >
> > I have done this but I still get the same error.
> >
> >
> > Any help on this would be greatly received.
> >
> > Andy Hallam
> > ahm_at_exel.co.uk
> >
> >
> >
> >
> >
Received on Sat Jul 21 2001 - 23:58:24 CEST