|
|
| Re: ODBC error on Windows 95 [message #100036 is a reply to message #99910] |
Tue, 25 June 2002 12:06   |
Mike Bailey
Messages: 1
Registered: June 2002
|
Junior Member |
|
|
I had a similar problem that occurred when the following events took place:
Launch MS Access and open a dummy database such as db1 or Northwind.
In the Tables Tab, choose File-Get External Data-Link Tables (from the File menu).
In the Files of Type drop down box, choose ODBC.
In the Data Source selection, go to the Machine Data Source tab.
At that time I chose to link to "Sandbox", a database we use for a project.
The following error would come up.
ORACLE ODBC DRIVER
Error: Cannot load resource file sqresus.dll
The process used to work until the user of the PC installed a piece of software called Clementine. On a hunch, I checked the autoexec.bat file (this was a Win98 PC) and sure enough, Clementine had altered the PATH statement. I don't know what (if anything) Clementine deleted out, but she added herself into the PATH. I still didn't know what changes to make to fix the problem, so I went to GOOGLE (God bless GOOGLE) and found this discussion. I tried the following fixes:
Copy the sqresus.dll file from the c:Orawin95bin directory to the c:WindowsSystem directory. Then try the above procedure. I received the following error.
OCI.DLL - One of the library files needed to run this application cannot be found.
I decided I would have to mess with the PATH statement. I backed up the autoexec.bat file in case I really butchered it, and then I made sure that c:Orawin95bin and c:Program FilesOraclejre1.1.7bin were the first 2 items in the PATH and the CLASSPATH statements. Then I rebooted (or else the changes do not take effect in Win95/Win98) and EVERYTHING WORKED!!! Thanks for your help, folks! Especially you, Jack Li.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
