Error Cannot Load Resource File sqresus.dll

[SkipVought]

Hi Fellow Colleagues,

I am posting this in several forums, because of the nature of this issue.

I'm running Office 2003, Oracle 9.2, Attachmate Extra!Personal Client 3270 emulator 5.1.2600.2180

I perform ODBC queries, to Oracle databases, in Excel, using MS Query. Works just fine.

I execute VBA to scrape an IMS screen in my emulator, with code like...

    Dim oSys As Object, oSess As Object, oScreen As Object
    
    Set oSys = CreateObject("Extra.System")
    
    Set oSess = oSys.activesession
    
    Set oScreen = oSess.screen
    
    Cells(1, 1).Value = oScreen.area(1, 1, 1, 80)
    
    Set oScreen = Nothing
    
    Set oSess = Nothing
    
    Set oSys = Nothing

Works just fine.

However, if I execute the above code, and then attempt to Data>Refresh my QueryTable in my Worksheet, I get the following error...
[tt]
---------------------------
Oracle ODBC Driver
---------------------------
Error Cannot Load Resource File sqresus.dll
---------------------------
OK
---------------------------
[/tt]
Followed by
[tt]
---------------------------
Microsoft Excel
---------------------------
Specified driver could not be loaded due to system error 1114 (Oracle in OraHome92).
---------------------------
OK
---------------------------
[/tt]
Followed by the Select Data Source Window. I must Cancel, CLOSE EXCEL & reopen to clear this error.

While in this state, I can Data>Edit Query, manipulate the data in the QBE grid, accessing the Oracle database all along, but as soon as I attempt to Edit>Return data to Excel, I get the error.

I have tried copying sqresus.dll and sqora32.dll from C:\orant\bin to C:\WINDOWS\system and C:\WINDOWS\system32, to no avail.

What else might I try?

Skip,

_[red][/red]