sqresus.dll error when using 8.00.58 or 8.00.57 ODBC driver?

When trying to make a system dsn ODBC connection using an Oracle 8.00.58 or 8.00.57 error I constantly receive an error message that states that The sqresus.dll could not be initialized.  Any help would be appreciated.
JillianAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

geotigerCommented:
Either you do not have sql*net install on the client or you are using mismatched version of ODBC driver.

More information from Oracle doc:

Problem Description
-------------------

Getting SQLSTATE:IM003 errors or other Connection failures when
trying to connect to a database using ODBC.

For Example:
 
a)  SQLSTATE:  IM003 Native Error Code:160
    Driver Message: Specified driver could not be loaded due
                       to system error 126 (Oracle 73)


b)  szSqlState = "08004", *pfNativeError = 1034, *pcbErrorMsg = 51,
                    *ColumnNumber = -1, *RowNumber = -1
    MessageText = "[Oracle][ODBC][Ora]ORA-01034: ORACLE not available
"


Solution Description
--------------------
Please check the following:

a) Is SQLNET installed on the client?
ODBC needs SQLNET to be installed on the client in order to use it
to talk to a remote server. The version of sqlnet you need on the
client depends on the version of the ODBC driver you are installing.
(see c) below for more details)

If you need to install SQLNET on the client then you should order
an Oracle Client CD from Oracle software distribution.
If you want to install a different version of ODBC which is
compatible with the version of SQLNET you have installed you can
download ODBC drivers from Metalink under

[Technical Libraries]
[Tools]
Programmatic Interface
ODBC

You will get the following types of errors from an odbc
application e.g. the odbctest program (installed with the driver)
when you do not have SQLNET installed:

ODBC Version               Error Message
-------------------------------------------
V815:                      OCI.DLL    The specified module could
                                      not be found
                           Error Cannot Load Resource File sqresus.dll
                           SQLSTATE: IM003
                           Native Error Code:160
                           Driver Message: Specified driver could
                           not be loaded due to system error 1114
                           (Oracle ODBC Driver)

V80X :                     Error Cannot Load Resource File sqresus.dll
                           SQLSTATE: IM003
                           Native Error Code:160
                           Driver Message: Specified driver could not
                           be loaded due to system error 1114
                           (Oracle ODBC Driver)

V2.5 (i.e. 7.3.4):         SQLSTATE:  IM003
                           Native Error Code:160
                           Driver Message: Specified driver could not
                           be loaded due to system error 126 (Oracle 73)



To test if sqlnet is installed on the client try connecting to
your server using sqlplus.  
If you are getting these types of errors but sqlplus IS working
then check b)

b) Your path is not pointing to c:/orant/bin (or c:orawin95/bin if
you are on win95) where c:/orant is your Oracle home directory.

You have installed sqlnet but your path is not pointing to the oracle
bin directory.
To check this, pull down a dos window and type PATH.  
If C:/ORANT/BIN or C:/ORAWIN95/BIN are not on your path
 (where C:/ORANT etc is the home directory for your sqlnet
  installation on the client)
then ODBC will not work.  To correct this problem use  
  Control Panel->System->Environment and
change the system or user 'path' variable to add c:/orant/bin
to the front of the path.

See a) for the types of errors you get when you do not have an
ORACLE_HOME/BIN directory on your path


c) You are using the wrong version of sqlnet for the odbc driver
 you have installed

If you are using a V7 odbc driver then you should have V7 (e.g. 2.3.4)
of sqlnet installed on the client, if you are using V805 odbc you
should have 805 sqlnet installed, if you are using V815 odbc
you should have V815 sqlnet installed on the client.  
In general ODBC does not mind what version the database is on the
 server so long as the Oracle sqlnet client will talk to it.
(For example, you can use a V815 odbc driver with V815 of sqlnet
 installed  on the client talking to a V734 database on the server.
 What you CANNOT do is using a V815 odbc driver with V734 of
 sqlnet installed on the client.)
This will also be the situation if you have two versions of Oracle
installed on the client and the incorrect Oracle bin directory
is first on the path.

These are the types of errors you will get in this situation:

i) You are using a V815 odbc driver but are using V805 of sqlnet
 on the client.

MsAccess:

ODBC - call failed
[Oracle][ODBC][Ora] ORA-01034 Oracle not available
{#1034][Microsoft][ODBC Driver Manager] Driver's SQLSet ConnectAttr
failed [\0]

ODBC test:
    dbc: szSqlState = "08004", *pfNativeError = 1034, *pcbErrorMsg = 51, *ColumnNumber = -1, *RowNumber = -
          MessageText = "[Oracle][ODBC][Ora]ORA-01034: ORACLE not
          available"

ii) You are using a V734 odbc driver but are using V815 of sqlnet on
the client.

   SQLSTATE:IM003
   Native Error Code:160
   Driver Message: Specified driver could not be loaded due to
   system error 126 [Oracle73 Version 2.5]


c) TNS type errors from odbc.  These types of errors indicate a
sqlnet error, not an ODBC problem.
You should be able to reproduce the error using sqlplus and then
 progress the issue as a sqlnet issue
(e.g the listener is not started on the server)
..


0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.