• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 3968
  • Last Modified:

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

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) !
0
scl1930
Asked:
scl1930
1 Solution
 
puppydogbuddyCommented:
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).

http://www.oracle.com/technology/tech/oci/instantclient/releasenotes/ODBC_IC_ReleaseNotes.html

0

Featured Post

[Webinar] Cloud and Mobile-First Strategy

Maybe you’ve fully adopted the cloud since the beginning. Or maybe you started with on-prem resources but are pursuing a “cloud and mobile first” strategy. Getting to that end state has its challenges. Discover how to build out a 100% cloud and mobile IT strategy in this webinar.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now