Hi,
On one machine, I get an error when I test a newly created MSDAORA connection.
TITLE: Connection Manager
------------------------------
Test connection failed because of an error in initializing provider. Oracle error occurred, but error message could not be retrieved from Oracle.
------------------------------
How could I do a clean uninstall of the Microsoft OLEDB provider for Oracle and re-install it.
Where could I find an installer for this
All other types of Oracle connection works so I know it is not tnsname nor Oracle store and the OLEDB for Oracle works on all other machines.
I tried to completely un-install SQL2005 and re-install it, nothing to do.
Thanks
Philippe
MSDAORA error on one machine
Hot Topic
- I can't dissable a dimension level
- Migration of DTS packages to SSIS
- XML Source - Generated XSD or XML Problem?
- Deployment Utility error
- denying read rights to a dimension
- Parent Package Variable visibility when designing packages
- Please help me with my Top N query
- Conversation ID cannot be associated with an active conversation
- VS 2005 - VB.NET - Connect to mobile SQL database from Desktop PC
- Client can not connect to SQL Express
SQL Server
- Matrix Subtotal
- Complex SQL query
- SSIS package Destination adapter
- Error Calling SQLCLR UDF
- Change Owner Dts Package
- SQL Server Management Studio Express: Missing DataBases from VWD Project
- How to mimic replmerg.exe in vb.net
- SSIS and COM
- Link 2 servers over web - best method query
- Programmatically loop over variables in the variable dispenser?
MSDAORA error on one machine
PhilMatt
Philippe,
I had the exact same issue. Just a couple of guesses - You have the oracle client installed on this same machine. Additionally, you have change the default home path where oracle was trying to install the corresponding client. If you do, I can’t take credit for this fix (but this should help):
http://mobeen.spaces.msn.com/blog/cns!C7EE59ADAEED6598!153.entry
Good Luck - BidDadddy
Gary Short
Well, I had a slighlty different scenario.
I had the Oracle store on the C drive because I knew they hard code C in places. I had errors like cannot find DLL xxx a few years ago when trying to use the first native Oracle provider for dotnet.
So, since nothing worked, including clean-un-install / reinstall of Oracle, I simply reformated the whole thing and rebuild it from scratch.
To get to install oracle 9.0.2 client, I had to make sure I had an Oracle folder in the C drive in the first place, otherwhise Oracle installer would hang at 33% :-). Other than that the rebuild went fine, including SQL SP1 install.
Now, the MS provider for Oracle works like a charm. I yet have to poke around to make sure SP1 did not cause any trouble but that is another story.
Oracle and Microsoft seems to have difficulties sharing the same workspace :-) I have other issues revolving around internet explorer and Oracle Java applications.
Regards,
Philippe