SQL Server 2008 R2 x64 connect to Oracle solutions

2010-12-15  来源:本站原创  分类:Database  人气:145 

I: Environment

Operating system environment: Windos Server 2008 R2 64bit

Required software version: SQLSERVER 2008 64 Bits

Oracle client 32-bit and Oracle client 64 Bits

II: the problem

With the Oracle client to connect to remote Oracle database can be, but when used to connect to SQL SERVER, always report did not provide a OraOLEDB.Oracle.1 error.

III: Solution

0, go to the official download Oracle 32-bit and 64-bit client. The following address:

http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html

1, install the 32 bit Oracle client and store the path C: \ Oracle \ product \ 11.2.0 \ client_ 32

2, install 64-bit Oracle client and store the path C: \ Oracle \ product \ 11.2.0 \ client_ 64

Will be reported when a low memory warning, ignored.

3, find the registry key HKEY_LOCAL_MACHINE \ SOFTWARE \ Microsoft \ MSDTC \ MTxOCI

OracleOciLib value to oci.dll, OracleSqlLib value to orasql11.dll, OracleXaLib value to oraclient11.dll.

4, HKEY_LOCAL_MACHINE \ SOFTWARE \ Wow6432Node \ Microsoft \ MSDTC \ MTxOCI modify it to do the same

Step 3 and 4 can not handle possible to solve the problem.

Fourth, the original

  1. Download 32 and 64-bit clients from http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html (Click "see All" to see Different versions, otherwise, you'll be Downloading the complete Oracle program. Your downloads should be about 600 meg each)
  2. Run 32-Bit install on the SQL Server. Select "Custom"
  3. For Oracle Base, enter "C: \ Oracle"
  4. For "Software Location", change to C: \ Oracle \ product \ 11.2.0 \ client_ 32
  5. Choose the following components:
  6. SQL * Plus
  7. Oracle Call Interface (OCI)
  8. Oracle Net
  9. Oracle Services for Microsoft Transaction Server
  10. Oracle Administration Assistant for Windows
  11. Oracle Provider for OLE DB
  12. Oracle Data Provider for. NET
  13. Oracle Providers for ASP.NET
  14. Repeat above steps with the 64-bit installer. HOWEVER, change the "Software Location" to C: \ Oracle \ product \ 11.2.0 \ client_ 64
  15. I got a memory error at this point, but chose to ignore it since I know there is enough
  16. Ignore the error "OracleMTSRecoveryService already exists"

Now that the install is done, just need to tweak a few things.

  1. Make registry changes to HKEY_LOCAL_MACHINE \ SOFTWARE \ Microsoft \ MSDTC \ MTxOCI
  2. OracleOciLib should be oci.dll
  3. OracleSqlLib should be orasql11.dll
  4. OracleXaLib should be oraclient11.dll
  5. Make same registry changes to HKEY_LOCAL_MACHINE \ SOFTWARE \ Wow6432Node \ Microsoft \ MSDTC \ MTxOCI
  6. Create or copy a new tnanames.ora in C: \ Oracle \ product \ 11.2.0 \ client_ 32 \ network \ admin
  7. Create or copy a new tnanames.ora in C: \ Oracle \ product \ 11.2.0 \ client_ 64 \ network \ admin
  8. Reboot!
  9. You should now see OraOLEDB.Oracle as a provider under Linked Servers \ Providers in SSMS
  10. Right-click this provider, then Properties, then tick the box for "Allow Inprocess"
  11. You can now create linked server through the GUI or T-SQL

Good luck!

Website:

http://efreedom.com/Question/2-175257/Install-Oracle-OLE-Drivers-Use-SQL-Server-2008-R2-X64

相关文章
  • SQL Server 2008 R2 x64 connect to Oracle solutions 2010-12-15

    I: Environment Operating system environment: Windos Server 2008 R2 64bit Required software version: SQLSERVER 2008 64 Bits Oracle client 32-bit and Oracle client 64 Bits II: the problem With the Oracle client to connect to remote Oracle database can

  • SQL Server 2008 R2 x64 Oracle connectivity solutions 2010-12-15

    A: Environment Operating system environment: Windos Server 2008 R2 64bit Required software version: SQLSERVER 2008 64 Bit Oracle client 32-bit and Oracle client 64 Bit II: Problems With the Oracle client to connect to remote Oracle database can be, b

  • Download SQL Server 2008 R2 2011-10-19

    Download SQL Server 2008 R2: On this page you can modify the language. . . You can also download the x86 and x64 self-extracting version, you can also download the AIO ISO. . . http://www.microsoft.com/downloads/zh-cn/details.aspx?familyid=54ad6107-c

  • SQL SERVER 2008 R2's banquet 2010-05-09

    SQL Server 2008 R2, code-named "Kilimanjaro", I use time-tested Chinese Pinyin people to a fight vigorously, it felt like a very familiar look. Also not to mention, it really is, Kilimanjaro (Africa's highest peak). The name never hidden the Mic

  • sql server 2008 R2 Data-tier Application of database upgrade to provide new methods 2010-05-14

    Database than the application upgrade is always difficult to upgrade. Application upgrade is complete coverage of no more than paper. And upgrade the database file can not simply do the overall coverage, but must take into account the existence of us

  • SQL Server 2008 R2 product key serial number key 2011-01-08

    SQL Server 2008 R2 serial number ========================================= SQL.Server.2008.R2_Sn ========================================= Data Center Edition: PTTFM-X467G-P7RH2-3Q6CG-4DMYB DDT3B-8W62X-P9JD6-8MX7M-HWK38 ==============================

  • SQL Server 2008 R2作业中无法新建与修改步骤的问题 2013-11-17

    在使用SQL Server 2008 R2时遇到这样一个问题,在SQL Server Agent >> Jobs中新建与修改步骤时出现下面的错误: TITLE: Microsoft SQL Server Management Studio ------------------------------ Creating an instance of the COM component with CLSID {AA40D1D6-CAEF-4A56-B9BB-D0D3DC976BA2} from t

  • SQL SERVER 2008 R2配置管理器出现"远程过程调用失败"(0x800706be)错误提示 2014-03-21

    本文主要记录了SQL SERVER 2008 R2配置管理器出现"远程过程调用失败"(0x800706be)错误提示的解决方法,图文并茂,非常的实用,有需要的朋友可以参考下 以前SQL Server 2008 不能登陆的时候,总是通过"计算机管理"→"SQL Server服务"更改一下,"SQL Server(MSSQLSERVER)".可是现在出现的问题却成了SQL Server服务打不开的情况,很是郁闷.如图: 通过网上查

  • SQL Server 2000向SQL Server 2008 R2推送数据图文教程 2014-09-16

    这篇文章主要介绍了SQL Server 2000向SQL Server 2008 R2推送数据图文教程,本文步骤详细,配图清晰,需要的朋友可以参考下 最近做的一个项目要获取存在于其他服务器的一些数据,为了安全起见,采用由其他"服务器"向我们服务器推送的方式实现.我们服务器使用的是sql server 2008 R2,其他"服务器"使用的都是SQL Server 2000,还都是运行在Windows XP上的,整个过程遇到了一些问题,也参考了一些文档,最终费了好多事才

  • SQL Server 2008 R2 应用及多服务器管理 2014-11-03

    所谓多服务器管理 (Multiserver Administration)就是SQL Server 2008 R2提供的自动管理多个 SQL Server 实例过程的功能.在多服务器管理中,连接到主服务器并从其接收作业的服务器被称之为目标服务器. SQL Server 2008 R2推出了管理SQL服务器数据库引擎的多个实例的SQL服务器工具,使用这些工具可以通过中央服务器对多个SQL Server服务器进行快速.高效的管理. 管理SQL引擎多实例的工具 使用SQL Server Managem

  • SQL Server 2008 R2数据库镜像部署图文教程 2014-12-21

    数据库镜像是一种针对数据库高可用性的基于软件的解决方案.其维护着一个数据库的两个相同的副本,这两个副本分别放置在不同的SQL Server数据库实例中 概述 "数据库镜像"是一种针对数据库高可用性的基于软件的解决方案.其维护着一个数据库的两个相同的副本,这两个副本分别放置在不同的SQL Server数据库实例中.建议使用不同位置的两台服务器来承载.在同一时刻,其中一台上的数据库用于客户端访问,充当"主体服务器"角色:而另一台则根据镜像会话的配置和状态,充当热备份服务

  • SQL Server 2008 R2英文版安装图文教程 2014-12-22

    SQL Server 2008 R2英文版安装图文教程,需要的朋友可以参考下 SQL Server 2008 R2英文版安装图解

  • SQL Server 2008 R2:error 26 开启远程连接详解 2015-02-28

    本篇文章小编为大家介绍,SQL Server 2008 R2:error 26 开启远程连接详解.需要的朋友参考下 在学习ASP.NET 过程用到新建数据集并远程连接sql server 2008 数据库,出现下面的错误: <--在与 SQL Server 建立连接时出现与网络相关的或特定于实例的错误. 未找到或无法访问服务器.请验证实例名称是否正确并且 SQL Server 已配置为允许远程连接. (provider: SQL Network Interfaces, error: 26 - 定

  • SQL Server 2008 R2 新功能你知多少? 2011-04-11

    SQL Server 2008 R2 新功能你体验了吗,现在四夕给大家介绍一下SQL Server 2008 R2 的新功能和SQL Server 2008 R2 增强功能有哪些? 一.SQL Server 2008 R2 新增功能: 1.PowerPivot for SharePoint PowerPivot for SharePoint 添加共享服务和基础结构,以便加载.查询和管理您发布到 SharePoint 2010 服务器或场的 PowerPivot 工作簿.若要创建 PowerPiv

  • SQL SERVER 2008 R2 重建索引的方法 2014-11-22

    项目升级数据库由SQL2000升级到2008R2,今天对数据库表进行碎片扫描,发现有些表碎片较大,于是决定重建索引,MSDN联机帮助是最好的老师,将相关脚本摘录备后查 参考sys.dm_db_index_physical_stats 检查索引碎片情况 1.SELECT 2.OBJECT_NAME(object_id) as objectname, 3.object_id AS objectid, 4.index_id AS indexid, 5.partition_number AS parti

  • 用JTDS连接SQL Server 2008 R2 2014-09-05

    1 首先要开启SqlServer的TCP/IP` 打开TCP/IP后`重启服务` 2 修改JTDS连接字符串` jdbc:jtds:sqlserver://192.168.1.10:1433;DatabaseName=test

  • oracle数据导入sql server 2008方法 2014-02-14

    随着社会的发展,各被审计单位的数据量也不断增加.过去常用的小型数据库已经不能适应时代的发展,大型数据库逐渐普遍起来,尤其以oracle数据为代表的大型数据库更是被众多单位.公司和企业采用,因此掌握oracle数据库的备份与还原显得尤为重要. 以下阐述的是将oracle数据导入sql server 2008的步骤. 第一步:配置数据源 开始→控制面板→管理工具→数据源(ODBC) 选择"系统DNS",单击"添加"按钮 选择"oracle in oradb11

  • SQL Server 2008 数据库镜像部署实例之一 数据库准备 2014-06-28

    利用Sql Server 2008 enterprise X64,建立异步(高性能)镜像数据库,同时建立见证服务器实现自动故障转移 一.目标 利用Sql Server 2008 enterprise X64,建立异步(高性能)镜像数据库,同时建立见证服务器实现自动故障转移. 二.前提条件.限制和建议 2.1.伙伴双方(主体服务器和镜像服务器)及见证服务器必须使用相同版本的Sql Server 2.2.如使用见证服务器,择须确保其系统上安装 Sql Server 2005或更高版本 2.3.在镜像

  • 通过SQL Server 2008数据库复制实现数据库同步备份 2014-10-25

    下面通过一个示例和大家一起学习一下如何部署SQL Server 2008数据库复制 SQL Server 2008数据库复制是通过发布/订阅的机制进行多台服务器之间的数据同步,我们把它用于数据库的同步备份.这里的同步备份指的是备份服务器与主服务器进行实时数据同步,正常情况下只使用主数据库服务器,备份服务器只在主服务器出现故障时投入使用.它是一种优于文件备份的数据库备份解决方案. 在选择数据库同步备份解决方案时,我们评估了两种方式:SQL Server 2008的数据库镜像和SQL Server

  • Strange SQL Server 2008 (1) 2011-05-19

    Grumbling: Install SQL Server 2008 these days to know, so many years engaged in the computer, the original installation software could be so difficult SQL Server 2008 server and SQL Server management tools installed, run the bcp error - "Unable to lo