.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

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

Posted By:      Posted Date: December 04, 2010    Points: 0   Category :Sql Server


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

View Complete Post

More Related Resource Links

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

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.

Server 2008 R2 -> Failed to decrypt using provider 'RsaProtectedConfigurationProvider'. Error mess


So I am using the aspnet_regiis.exe tool to encrypt sections of the web.config in my asp.net applications and services.  I have done this for years successfully on Windows Server 2003 (IIS 6).  However I just moved some apps over to Windows Server 2008 R2 (with IIS 7.5) and I am now receiving the following error at runtime:

"Server was unable to process request. ---> Failed to decrypt using provider 'RsaProtectedConfigurationProvider'. Error message from the provider: Bad Data."

Now I am quite familiar with this process and am stumped at what I have missed this time around.  I have done ALL of the following which typically suffices for the process on the server. PLEASE READ ALL AND DO NOT PROVIDE RESPONSES OR LINKS FOR THINGS I HAVE ALREADY DONE Thanks!!  Wink

  1. Imported the keys to the server using aspnet_regiis -pi  Result: Success
  2. Given FULL permission (using -full switch) using aspnet_regiis -pa to ALL of the following accounts  Result: Success
    1. 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

How I can remove The Microsoft SQL Server 2008 Express installation manually.

How I can remove The Microsoft SQL Server 2008 Express installation manually ?   Other components uninstalled via Add/Remove but i cant remove SQL Server 2008 Express     From Add/Remove the following is installed:Microsoft SQL Server 2008   I have attempted to uninstall it via the Add/Remove method and this also failed.

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.

SQL server 2008 to oracle replication

Hi, I am trying to replicate data from a sqlserver to an oracle 11 subscriber(push subscription). I recently moved to SQL server 2008 from 2005. The replication in 2005 worked ok, and now in 2008 - it does not. The problem: It tries to make some fields as an interval data type in Oracle. For example, nvarchar(3) are turned into interval and numeric(38,8) fields are turned into nvarchar2(40). Anyone has any idea why is this happening and how can I change it?

Error while trying to register DLLs for Microsoft Jet on Windows Server 2008 R2 64bit

Hello! I'm having issues with importing Excel spreadsheets into Microsoft SQL Server 2005 on a Windows Server 2008 R2 64bit server.  After browsing the web, it appears that the problem is with the DLL's used by Microsoft Jet.  I've thus attempted to re-register these DLL's.  However, I am receiving the following results. c:\Windows\SysWOW64> regsvr32 c:\Windows\SysWOW64\msjetoledb40.dllSuccessful c:\Windows\SysWOW64> regsvr32 c:\Windows\SysWOW64\msjet40.dllSuccessful c:\Windows\SysWOW64> regsvr32 c:\Windows\SysWOW64\msjint40.dllThe module "msjint40.dll" was loaded but the entry-point DLLRegisterServer was not found c:\Windows\SysWOW64> regsvr32 c:\Windows\SysWOW64\msjter40.dllThe module "msjter40.dll" was loaded but the entry-point DLLRegisterServer was not found c:\Windows\SysWOW64> regsvr32 c:\Windows\SysWOW64\msjtes40.dllSuccessful c:\Windows\SysWOW64> regsvr32 c:\Windows\SysWOW64\mswstr10.dllThe module "mswstr10.dll" was loaded but the entry-point DLLRegisterServer was not found I've set the application pool for this site to use 32bit.  Please note that due to my role on the team, other options such as using ACE are not available to me, unless I can prove that I've exhausted all other options. Thoughts? Thanks,Mike

OLE DB Provider MSDAORA for SQL Server 2008(64 bit)

Hi, Going forward our product would support on SQL Server 2008(both 32 bit and 64 bit).We do migrate data in our application from Oarcle to SQL Server using LINKED Server using provider is 'MSDAORA'.We never ever had any issue in migration for any SQL Server versions. but for migration data from Oracle 11G 64-bit to SQL Server 2008 64 bit we are facing issue says 'The OLE DB provider "MSDAORA" has not registered'. I pulled this from a Microsoft forum: “MSDAORA is old and designed for Oracle 8. Currently Microsoft does not provide any 64-bit provider for Oracle.” Please let me know how to resolve this issue. Regards,

Cannot Connect SQLServer 2008 with the provider SQLNCLI... Is there any SQL Server 2008 patch to sup

We have a program which developed under SQL Server 2005. In the program the provider of the connect string is hard coded as "SQLNCLI". It's ok running on SQL Server 2005. Now, for some reasons, this program must run under SQL Server 2008 (x64). But our program cannot access the SQL Server. We check the reason, found that, in SQL Server 2008, SQLNCLI is changed to SQLNCLI10, this caused our program cannot run. So I want to ask, is there any patch of SQL2008, so that the legacy program can normal access SQLserver with SQLNCLI WITHOUT rebuild a new version?  

Transforing the Data from Oracle to SQL Server 2008

Hi all I have to create a SSIS package which can Transfer the Data from Oracle to SQL Server 2008. Every time when packages run it will suppose to create tables in SQL Server Database. I guess it is possible with export and Import, but the privies tables suppose be deleting before or after dumping.   Suggest me best method to do this.     Thanks in advance     SNIVAS

Server 2008 R2 64 bit, SSRS 2008 64 bit with Report Builder 3.0 issues with Oracle OLE Driver

Folks, ran out of idea on this issues. Setup as shown at the Title. I can connect via VS 2010  but report builder cannot run properly when setup with connection string. I use a 32 bit Oracle Driver and VS 2010 works well with it, however, Report Builder on SSRS report a bad image issues while attempting to use the same driver. What have been tried: 1-Already attempted to try to download Oracle ODP drivers 64 bit, but current driver 11g and minor version above 11g does not install, installation failed. So far all chats indicated that Server 2008 R2 does not have a Oracle 64 bit driver provided y Oracle. Any help is appreciated ....    

Configuration Wizard - Stuck on Microsoft SQL Server 2008

I have tried this three times and don't know what to try to be different. Configuration Wizard - Microsoft SQL server 2008  R2 Fails on Microsoft SQL server 2008  R2 Microsoft SQL server 2008  R2 is required in this training Kit Down load I have go though the download process at least 3 times and the configuration wizard still gets stuck on this step.   Any suggestions are appreciated.   I have a Window 7 PC.  

Does "Microsoft OLE DB Provider for SQL Server" get different versions for SQL2005 and SQL2008?

We know SQLServer OLE DB have two driver types: SQL Native Client and Microsoft OLE DB Provider. I know The former one have different versions for SQLServer2005 and SQLServer 2008 (SQLNCLI.DLL, SQLNCLI10.DLL), right? And for latter one, does it have different versions? I only got SQLOLEDB.dll under system32 folder, but have no idea whether it have different versions. Can some one help me?   Thanks Spring  

Help with Microsoft Authorisation Manager (Azman) for Windows Server 2008 and XP Dev

Morning all, I am hoping someone can shed some light on a problem i have as i seem to be at a dead end and cannot find a resolution. Even Google!   My scenario is as follows: 1) I have Azman installed on a windows 2008 server with the database hosted on SQL server. 2) I have an application that im developing in a Windows XP environment using a version managed PIA for AzMan (Microsoft.Interop.Security.AzRoles). When the application loads, and the following statement is executed: AzAuthorizationStoreClass store = new AzAuthorizationStoreClass(); store.Initialize(0, this.storeLocation, null); ... i get an exception which is thrown by .Initialise: "The specified network provider name is invalid. (Exception from HRESULT: 0x800704B4)" the storeLocation is set and read from the configuration file as: <add key="storeLocation" value="mssql://Driver={SQL Server};Server={my2008server};/AzManDb/MyTestApplication" /> Any help is very much appreciated.  

The OLE DB provider "Microsoft.ACE.OLEDB.12.0" for linked server "(null)" reported an error. Access

Hi,I am importing Excel 2007 file into SqlServer 2005 (Sqlexpress). The office 2007 is not installed in the machine. I have downloaded and installed "AccessDatabaseEngine". When I execute following statement SELECT * FROM OPENROWSET('Microsoft.ACE.OLEDB.12.0', 'Excel 12.0;Database=D:\File1.xlsx', 'SELECT * FROM [Sheet1$]');The following error is comming:Msg 7399, Level 16, State 1, Line 1The OLE DB provider "Microsoft.ACE.OLEDB.12.0" for linked server "(null)" reported an error. Access denied.Msg 7350, Level 16, State 2, Line 1Cannot get the column information from OLE DB provider "Microsoft.ACE.OLEDB.12.0" for linked server "(null)".Can any one suggest what should I do to resolve?Thanks,Parmeshthee. Learning .Net 3.5

Selecting ODP.NET (provider for Oracle) in Reporting Services 2008 R2 x64, Report Builder 3.0, Busin

We have a requirement to connect Reporting Services 2008 R2 x64 + Report Builder 3.0 to Oracle database and also to build a web application which connects to Oracle. I installed ODAC (Oracle Data Access Components) which contains ODP.NET (Oracle Data Provider for .NET) and Instant Client (required by the provider). Now the problem is how to make Report Designer, Reporting Services and Report Builder 3.0 to add ODP.NET as an Oracle provider in the drop down list contained by the Data Source Wizard? I found out that Reporting Services and Report Builder work based on Data Extensions so I added Oracle.DataAccess as extension to RsReportServer.config and RsReportDesigner.config as shown in: http://www.bigresource.com/Tracker/Track-ms_sql-aIXqXMEE/. By changing RsReportDesigner the ODP.NET appeared in the list for Report Designer (Business Intelligence Studio) but it couldn't be used because an error was thrown as soon as Test Connection was pressed stating that the provider is not registered with the application. With these changes ODP.NET does not appear in the list of providers for Reporting Services and Report Builder 3.0. For now I managed to connect to Oracle through .NET Provider for Oracle (provided by default) but this seems to be deprecated and in Report Builder 3.0 I can't select tables to be added to the query, I'm prompted only with a blank textbox and one excla
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