.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Oracle connection fail with Microsoft OLEDB provider for Oracle MSDAORA.1

Posted By:      Posted Date: October 14, 2010    Points: 0   Category :Sql Server


On my dev server I have working ssis packages that use connections Microsoft OLEDB provider for Oracle MSDAORA.1 and Oracle provider for oledb and OracleClient data provider.

I use one or the other according to my needs.

In anticipation and to prepare for the build of a new production server, I have build a test server from scratch and deployed to it the entire dev.

Almost everything works except Microsoft OLEDB provider for Oracle.

ssis packages on the test machine will return an error

Error at Pull Calendar from One [OLE DB Source [1]]: The AcquireConnection method call to the connection manager "one.oledb" failed with error code 0xC0202009.

Error at Pull Calendar from One [DTS.Pipeline]: component "OLE DB Source" (1) failed validation and returned error code 0xC020801C.

[Connection manager "one.oledb"]: An OLE DB error has occurred. Error code: 0x80004005.

An OLE DB record is available. Source: "Microsoft OLE DB Provider for Oracle" Hresult: 0x80004005 Description: "Oracle error occurred, but error message could not be retrieved from Oracle.".

I have used the same installers for OS, SQL and Oracle SQL*Net on both dev and test machines. The in

View Complete Post

More Related Resource Links

What's wrong with MSDAORA.1 (Microsoft OLE DB Provider for Oracle) in SQL2008R2

Dear Gurus, I'd install a test SQL2008R2 on Windows Server 2008 R2 x64 Version. And Install Oracle both x86 and x64 version Client. And I'd create a new AS Database as AS System Administrator. And then create a new Datasource with "Microsoft OLE DB Prodiver for Oracle" Provider. When I test connection ,  it tested succeed. Then I create Datasource View / Dimension / Cubes etc... But when I process then Database. There is a error occurs. "Database Access Module Error , Provider 'MSDAORA.1' not register" I'd follow http://msdn.microsoft.com/en-us/library/ms152516.aspx change SQL Server 2008 R2's registry key as the note. Then restart this server . But still same error !   And I'd success process the cube if I change provider as "Oracle OLE DB Proverder"   Is MSDAORA been obsolete in SQL SERVER 2008 R2 ?Wilson

Not able to see microsoft oledb provider for oracle in sql server 2005 providers



can any one help me, environment window server 2003  64 bit and sql server 2005 sp3 64 bit and i have installed oracle client  10g 32 bit. problem is, I am not able to see the provider name  while creating linked server.

Trying to connect to Microsoft OLEDB Provider for Oracle ...but giving the following error


Hi All,

When I am trying to Connect to Oracle 11g using SSIS OLEDB source adapter ....Its giving me the following error.

TITLE: Connection Manager

Test connection failed because of an error in initializing provider. ORA-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA

Tried various ways by changing the TNSNames file and Sqlnet file...but I am unable to connect to oracle database...

If any body have any ideas...can you share with me ASAP...Appreciate your help.




Need Oracle Data Provider .CS File for Oracle 10g Database connection !



I need a 'Wrapper.cs' file which takes care of the Database connection ( Oracle 10g) where

i can just call the method with my SQL Query


Gridview1.DataSource = SampleWrapper.ExecuteDatatable("THE SQL QUERY");


Plz Post the link if there is any open source !    

How to install Microsoft OLE DB Provider for Oracle

I am using an SSIS Package to get the data from Oracle DB to  SQL server 2005 DB. I am using Micorsoft OLE DB provider for oracle for creating a connection manager to connect to ORACLE 10 g.   The package runs great in my local PC.  when I move the package to the Server ( Microsoft windows server 2003 R2, Enterprise x64 edition) which also has SQL server 2005 .  the package fails to run showing the error: " the AcquireConnection method call to the connection manager "HRDATA" failed with error code 0xC0202009."   I tried to see if the Microst OLE DB provider for  Oracle is installed or not  using the .udl file.  The provider tab in .udl file does not show any provider named " Microsoft OLE  DB provider for Oracle"   Can anyone please help me by telling how can I installed the Microsoft OLEDB provider for Oracle, given my server is ( Microsoft windows server 2003 R2, Enterprise x64 edition)  and my source data base is  ORACLE 10g.

Microsoft ole provider for oracle is not available in my VS 2008 list of providers when setting up C

Hi, Trying to set up a connection manager using Microsoft OLE Provider for Oracle, but it is not in the list of Providers. I do have Oracle Provider for OLE DB. But I need the former. I tried installing MDAC 2.8 but I get a message saying that it cannot be installed because it is part of the OS already. So, how do I get Microsoft OLE Provider for Oracle as an available provider? Thanks!--ACG

How to create a source component using Oracle oledb connection


How to create a source component using Oracle oledb connection in x64??


Problem in connecting to oracle database,which is using Provider=MSDAORA.1


Hi I am Naveen, I am upgrading a internal website from .Net 1.1 to .Net2.0 in Vb.

The database is deployed in the server, but i could not connect to that database.

i have to connect database to few drop down lists,

my manager has given connection string to me... i have placed it in web.config and given that link properly in the code..

but the database is not connecting.. the list is showing empty..

my conn string is

<add key="D2" value="Provider=MSDAORA.1;Data Source=baan; User ID=xxxx; Password=xxxx;Persist Security Info=True"/>

can anyone help me,,, thanks in advance...

Microsoft OLE DB Provider for Oracle 64-Bit, SQL Server 2008: Does it exist?



Does anyone know if the "Microsoft OLE DB Provider for Oracle" in 64-Bit Windows exists in SQL Server 2008 64-bit?  It only existed in 32-bit SQL 2005,  which was a big problem.    Needed for Linked Server creation.  We do not want to use OPENQUERY calls with the native Oracle 10G driver,  too many coding changes.


Thank You

Trying to run a stored procedure from vb code with oracle data provider.



Here is my SP:

create or replace
 Open p_getuserssignon_recordset1 for
 SELECT Distinct(Userid), UserPassword, SecurityLevel, ActiveStatus
WHERE substr(UserId,1,2) <> vUid
Order By UserId;

I would like to run this SP from code and fill a gridview with the result. 

I am not sure how to go about this, as I have found several different examples, other than the one I  think I need.

I am using the oracle data provider and I have an input parameter (vUid, which will equal "zz").

First question. When filling a gridview with a result set from a stored procedure should the recordset OUT be defined as a REFCURSOR (like i did above)? 


Do you have example code as to how to execute the SP and fill a gridview?  I keep trying different variations of code i've found on the internet without any success other than getting more confused.

(I am using VS 2005, VB).

Thank you.



Secured Oracle Provider



Ours is a Asp.net web application. Database is Oracle. Its an Internet Application.

Database will be in one location and Web application in another. Data from Oracle to Web application will be passed over Internet.

We are using EnterpriseLibrary. And provider is System.Data.OracleClient.

We need a provider which encrypts the data while passing data over internet.

Do we need to go for some third party Providers or ODBC ?

Please let me know..


Connection to Oracle

I am currently working on the connection between ASP.NET and Oracle. I tried to search over the net and know there are many ways. Is there any 'normal practice' on which method to be used? Or it depends? I tried with OLEDB connection provided by .NET and it appears to be fine.   Thanks a lot!

The provider is not compatible with the version of Oracle client

I am having the error stated above. The stack trace is as follows: [OracleException: The provider is not compatible with the version of Oracle client] Oracle.DataAccess.Client.OracleInit.Initialize() +550 Oracle.DataAccess.Client.OracleConnection..cctor() +518 [TypeInitializationException: The type initializer for 'Oracle.DataAccess.Client.OracleConnection' threw an exception.] Oracle.DataAccess.Client.OracleConnection..ctor() +51 InputForm.SelectRegion() +123 InputForm.Initialize() +952 InputForm.Page_Load(Object sender, EventArgs e) +53 System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) +25 System.Web.UI.Control.LoadRecursive() +71 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +3048   Some info's: Server: Windows Server 2008 R2 .NET Framework Version:4.0.30319; ASP.NET Version:4.0.30319.1 Oracle.DataAccess, Version= Dev Computer: Windows Vista Business 32bit .NET Framework Version:4.0.30319; ASP.NET Version:4.0.30319.1 Oracle.DataAccess, Version= My Code: OracleConnection cn;String con1 = ConfigurationManager.ConnectionStrings["myConnectionString"].ToString();cn = new OracleConnection();cn.ConnectionString = con1;cn.Open(); string mysql = "select region_code, 'Region ' || reg_

The OLE DB provider "Microsoft.Jet.OLEDB.4.0" has not been registered

Dear All, I am getting the below error while converting Excel 2007 file into text format with my customization. Error: 'The OLE DB provider "Microsoft.Jet.OLEDB.4.0" has not been registered' Enviromnet : Windows Server 2008 Enterprise 64 bit with SP2 and SQL Server 2008 64 bit installed. Some times its working fine when i registerd C:\Program Files (x86)\Common Files\System\Ole DB\sqloledb.dll file through regsvr32 and restarting SQL Server. But after few days again i am getting the same error. Can some one help me in resolving this issue. Regards, Jignesh

The provider reported an unexpected catestrophic failure using BETA MICROSOFT.ACE.OLEDB.14.0 drivers

I'm just in the process of converting my app to be able to support text importing via "OPENROWSET" in 64 bit SQL Server using the Beta MICROSOFT.ACE.OLEDB.14.0 drivers.  I've previously used the MICROSOFT.ACE.OLEDB.12.0 drivers but of course these only work on 32 bit instances of SQL Server.  I've found that after I've installed the beta that the connections wont work if I use MICROSOFT.ACE.OLEDB.14.0 as the provider.  However if I use MICROSOFT.ACE.OLEDB.12.0 it works... sort of... I can import data a few times then I get a "The provider reported an unexpected catestrophic failure" error and the app hangs.My environment is 64-bit Windows 7 running VM Workstation, with a 64-bit Windows 7 guest running SQL Server 2008 64 Bit.  Essentially I'm running the following which works... occasionally getting the failure above select top 50 * FROM OPENROWSET('Microsoft.ACE.OLEDB.12.0','Text;Database=c:\temp\captell;HDR=Yes', 'SELECT * FROM [DASDGIGS0013046591395.TXT]')and select top 50 * FROM OPENROWSET('Microsoft.ACE.OLEDB.14.0','Text;Database=c:\temp\captell;HDR=Yes', 'SELECT * FROM [DASDGIGS0013046591395.TXT]')Which doesn't work, returning the "OLEDB provider ... has not been registered" message.So I'm thinking that the drivers are 64-bit drivers but the registration process during installation is using

The provider is not compatible with the version of Oracle client

We are getting following error message while trying to execute sql package thru 'ExecuteNonQuery' our .NET code. This was working perfectly few days back, but suddenly VS2008 on our local is not able to execute the code. We are not sure what had exactly happened here, but code stopped working  on all develop machine all of sudden    Details for the error are as follows "The provider is not compatible with the version of Oracle client" or sometimes "Typeinitializer exception" We were using oracle.dataacess.dll version which was working fine.It still works fine when we deploy it in the production. We checked the GAC of the developer machines and Server,i found one difference that in the GAC of the server only the is installed while on the developer machines,two version of oracle.client are installed in the GAC,one is and the other is When we run the code,it might be the case that .net framework is picking up and that may be the problem,so we tried to include it in our project and that still gave us the same error !.We requested to uninstall from developer machines but client refuses to uninstall that its security fix and can not remove it ! Than we thought to upgrade the version of oracle.dataacess.dll to and code started working but it started giving onther trouble..which is

64bit MSDAORA.DLL for Oracle Connectivity

Hi, I have an 64 bit machine with 2008R2 Enterprise Edition SQL Server. InOrder to connect to Oracle, I need MSDAORA 64 bit version DLL to get registered. Where can i download this DLL and how to register it. Please let me know ASAP, Thanks in Advance. Srini..
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend