This content has been marked as final. Show 3 replies
After some more research, I found the issue to my problem. In the readme.htm file that's included in the unzipped 64-bit providers folder, it explains that after you install the files through install.bat, you need to place the location you installed the files in the PATH variable for windows. For example, if you use the install.bat file to install the files at C:\Oracle, you need to place the paths "C:Oracle" and C:\Oracle\bin" in the PATH variable. You can find this variable by right-clicking on My computer and selecting Properties (for Windows Vista/7 users, it's right clicking on Computer then properties then advanced system settings). Click on the Advanced tab and click the Environment Variables button. In the Systems variables list, you'll find the PATH variable. I hope this helps someone else.... I worked on getting the oledb provider to work for days...
Thanks, Jonathan, it helped. I was deploying SSIS package (which uses Oracle OLE DB provider) to a 64-bit environment and faced the same issue.
Wow, who new that old DOS-age path stuff still matters!
I have installed the 64 bit ORAOLEDB and I get the above message:
1. When I run it on my local machine it accesses the Oracle on another server successfully, but
2. When i deploy the c# app to another machine I get this error above.
2a. The other machines DSN test connection works fine.
3. I have set the environment PATH
4. I Have regsvr32'd the dll
5. I have re checked the permissions boxes
on the deployed machine, with no luck.
Im at a loss????