error connecting to oracle

fahad · Post by **fahad** » Mon Jun 27, 2005 8:47 am

Hi all,
i have jobs running fine, i moved these jobs to new server (windows 2000) and when trying to get data from oracle 8 it gives this error:
"ds_loadlibrary:Win32 error in LoadLibrary of oraoci8.dll - The specified module could not be found"
i removed oracle client and installed it again but didn't work.. i also verified the setting value in the registry but nothing came up to me..
any idea??
thanks in advane

elavenil · Post by **elavenil** » Mon Jun 27, 2005 9:20 am

Check your oracle library path was included in the path.

HTWH.

Regards
Saravanan

fahad · Post by **fahad** » Mon Jun 27, 2005 9:40 am

if you mean the Windows system path, yes oracle path is included.

elavenil · Post by **elavenil** » Mon Jun 27, 2005 9:53 am

Windows path should include the JRE (Java Runtime Executables) entries. We had the same problem in our project and we found that the JRE that was installed was a different version than expected. So pls check the windows path to ensure the JRE path included in the path. And check the version of JRE as well.

This is the path, which was set in our server.

C:\oracle\ora92\bin;C:\Program Files\Oracle\jre\1.3.1\bin;C:\Program Files\Oracle\jre\1.1.8\bin;

HTWH.

Regards
Saravanan

ds_developer · Post by **ds_developer** » Mon Jun 27, 2005 11:17 am

Check that the user name that is used when running the job has OS permissions to the file.

John

fahad · Post by **fahad** » Tue Jun 28, 2005 1:35 am

the path is there.. and the user is administrator.

fahad · Post by **fahad** » Tue Jun 28, 2005 2:17 am

imagin.. i restarted windows and it worked...
welcome to the World of Windows...

thanks guys