Oracle ODBC Driver: Error cannot load resource file sqresus.dll

Posted on 2009-12-31
Last Modified: 2012-05-08
error when running a report from Access 2007 (connecting to Oracle DB thru ODBC 8i):

Error cannot load resource file sqresus.dll

Looks like this error happens after SP2 for Office 2007 was installed (to fix the issue with Access 2007 unable to export to Excel) !
Question by:scl1930
    1 Comment
    LVL 38

    Accepted Solution

    In reviewing the discussion of your error on the Public Forums, the common thread seems to be that installing new software of any kind occasionally causes an alteration in the odbc driver file path if the newly installed software inserts itself into the file path.  Try resetting the odbc driver path in the autoexec.bat file as it should be, and then rebooting the system so that the new setting is activated.

    If the above does not fix the problem, then you probably need to uninstall and reinstall the Oracle ODBC Instant Client as discussed in the following link for Oracle 10 Instant Client release notes (the same thing should apply to your version of Oracle ODBC Instant Client).


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Enabling OSINT in Activity Based Intelligence

    Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

    Introduction When developing Access applications, often we need to know whether an object exists.  This article presents a quick and reliable routine to determine if an object exists without that object being opened. If you wanted to inspect/ite…
    In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
    As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
    Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…

    760 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    12 Experts available now in Live!

    Get 1:1 Help Now