==================================================
ORACLE PROVIDERS FOR ASP.NET 11.2.0.2.0 Production
==================================================
Copyright (c) 2010, Oracle and/or its affiliates. All rights reserved.
This document provides information that supplements the Oracle Providers
for ASP.NET Production documentation.
===============
IMPORTANT NOTES
===============
Oracle providers for ASP.NET support .NET Framework 2.0 and higher.
============================
INSTALLATION AND SETUP NOTES
============================
1. Product Dependencies
Oracle Providers for ASP.NET requires Oracle Client 11.2.0.2.0 or Oracle
Instant Client 11.2.0.2.0. When installing a new Oracle Providers for ASP.NET
11.2.0.2.0 instance, Oracle Universal Installer (OUI) will automatically
install Oracle Instant Client 11.2.0.2.0.
2. Policy DLLs
Note that the installation of this product places policy DLLS into the GAC so
that existing applications can start using newly installed version of this
product immediately after installation. However, if this is not desired, be
sure to remove the policy DLLs from the GAC.
3. Oracle Providers for ASP.NET 11.2.0.2.0 - Database Set Up
Before using Oracle Providers for ASP.NET 11.2.0.2.0, execute the database
SQL scripts that were part of the installation. Note that Oracle Providers for
ASP.NET ships with InstallAllOracleASPNETProviders.sql which will create all
the database objects for all the providers. If you already have an older version
of Oracle Providers for ASP.NET installed, the execution of
InstallAllOracleASPNETProviders.sql will update the stored procedures and column
definitions, but tables will not be dropped nor re-created.
==================================
TIPS, LIMITATIONS AND KNOWN ISSUES
==================================
1. If the HKEY_LOCAL_MACHINE\Software\Oracle\NLS_LANG registry entry is
set to "NA", ORA-12705 errors will be encountered when using Oracle
Providers for ASP.NET. To eliminate this problem, remove the
HKEY_LOCAL_MACHINE\Software\Oracle\NLS_LANG registry entry.
================================
AUTOMATIC MACHINE.CONFIG CHANGES
================================
After the installation of Oracle Providers for ASP.NET,
%windir%\Microsoft.NET\Framework\v2.0.50727\CONFIG\machine.config
file will be updated to make the system aware of the ASP.NET providers
that were installed. In addition, a connection string alias of
"OraAspNetConString" is added, which is referenced by each of the Oracle
Providers for ASP.NET. Below are typical entries that will be made in the
machine.config after the install.
(NOTE: You do not need to make these entries in the machine.config.
This is for your information only.)
(NOTE: "..." are place holders for existing entries in the machine.config.)
<configuration>
...
<connectionStrings>
...
<add name="OraAspNetConString" providerName="Oracle.DataAccess.Client" connectionString=" " />
</connectionStrings>
...
<system.web>
...
<membership>
<providers>
<add name="OracleMembershipProvider" type="Oracle.Web.Security.OracleMembershipProvider, Oracle.Web, Version=2.112.2.0, Culture=neutral, PublicKeyToken=89b483f429c47342" connectionStringName="OraAspNetConString" applicationName="" enablePasswordRetrieval="false" enablePasswordReset="true" requiresQuestionAndAnswer="true" requiresUniqueEmail="false" passwordFormat="Hashed" maxInvalidPasswordAttempts="5" minRequiredPasswordLength="7" minRequiredNonalphanumericCharacters="1" passwordAttemptWindow="10" passwordStrengthRegularExpression="" />
...
</providers>
</membership>
...
</system.web>
...
</configuration>
The above example shows just an entry for the Oracle Membership Provider.
There will be similar entries for other providers.
=====================
QUICK SETUP REFERENCE
=====================
Below are the quick setup steps for Oracle Providers for ASP.NET.
The steps below assumes that Oracle 11g 11.2.0.2.0 Production
was installed under a valid Oracle Home which will be referred to as
%ORACLE_HOME% henceforth in this readme.txt.
1. SQL*Net Setup
a) EZCONNECT
Either EZCONNECT or TNSNAMES can be used to connect to Oracle for
executing the Oracle Providers for ASP.NET setup scripts as well as for
the providers to connect to Oracle. To connect to the database using
either approach, %ORACLE_HOME%\Network\Admin\sqlnet.ora file must be
created to contain:
NAMES.DIRECTORY_PATH = (TNSNAMES, EZCONNECT)
To be able to connect using OS Authentication, the following line is
also needed to be included in sqlnet.ora:
SQLNET.AUTHENTICATION_SERVICES = (NTS)
To use EZCONNECT, the data source must be specified in the following
format (and no other configuration file is needed):
[//]host[:port][/service_name][/server][/instance_name]
b) TNSNAMES
To use TNSNAMES, a tnsnames.ora file must be also created in or
copied to the %ORACLE_HOME%\Network\Admin directory.
The %ORACLE_HOME%\Network\Admin\tnsnames.ora file can be created, for
example, to contain the following:
oracle =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = my-pc)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
The protocol, host, port, and service name in the tnsnames.ora should be
modified appropriately. If TNSNAMES is to be used, the TNSNAMES alias
is specified as the "data source", which in the example above is "oracle".
2. Executing the SQL Scripts
As noted during the install, the setup SQL scripts must be executed before
using any of the Oracle Providers for ASP.NET. For details, please see
Chapter 1 of the Oracle Providers for ASP.NET Developer's Guide.
If you don't have SQL*Plus to execute SQL scripts, you may install and use
Oracle Developer Tools (ODT) for Visual Studio 2005 or 2008 to execute those
scripts. Below are the steps:
a) Start up Visual Studio 2005 or 2008 IDE. Under Tools menu, select Run
SQL*Plus Script.
b) In the 'Run SQL*Plus Script' dialog box, click New Connection button.
c) In the Connection Properties dialog box, select "Oracle Database
Server (Oracle ODP.NET)" for Data Source and "Oracle Data Provider
for .NET" for Data Provider. Select a TNS alias
from Data Source Name drop-down list. If no entry is available, see
SQL*Net setup above. Enter a username and password, or select Use
Windows integrated authentication. Click Test Connection button to
test the connection. If it's successful, click the OK button to
continue.
NOTE: The scripts will create tables, stored procedures, views, and
roles. They will be owned by the database user that executed the
scripts. If the ASP.NET applications connect to the database as a
different database user than the database user that executed the
scripts, the database user (who owns the database objects that were
created for ASP.NET providers) will need to grant roles to other
database users, if they require access. For further details, please
read Chapter 1 of the Oracle Providers for ASP.NET user's Guide for
details.
d) Back in the 'Run SQL*Plus Script' dialog box, browse and select the
SQL scripts to run. Typically, the location of the scripts is
%ORACLE_HOME%\ASP.NET\SQL.
e) The InstallOracleASPNETCommon.sql script must be executed first
before executing any scripts for other Oracle Providers for ASP.NET.
Ho
没有合适的资源?快使用搜索试试~ 我知道了~
SQL SERVER 安装ORACLE provider for OLE DB 的连接服务驱动.zip
共195个文件
dll:90个
sql:42个
plb:17个
5星 · 超过95%的资源 需积分: 42 105 下载量 77 浏览量
2019-11-29
16:23:09
上传
评论
收藏 53.52MB ZIP 举报
温馨提示
在为SQL SERVER创建ORACLE的连接服务器时,没有ORACLE provider for OLE DB 的连接服务驱动。经网上搜索,把PDF安装说明和驱动程序一起收藏,请各位下载;
资源推荐
资源详情
资源评论
收起资源包目录
SQL SERVER 安装ORACLE provider for OLE DB 的连接服务驱动.zip (195个子文件)
BASIC_README 586B
configure.bat 25KB
uninstall.bat 19KB
unconfigure.bat 12KB
install.bat 11KB
genreg.bat 2KB
Policy.2.111.Oracle.DataAccess.config 399B
Policy.2.102.Oracle.DataAccess.config 399B
Policy.4.112.Oracle.DataAccess.config 393B
Policy.2.112.Oracle.DataAccess.config 393B
Policy.2.111.Oracle.Web.config 392B
Policy.4.112.Oracle.Web.config 386B
Policy.2.112.Oracle.Web.config 386B
oraociei11.dll 133.24MB
orannzsbb11.dll 1.49MB
oraocci11.dll 1.26MB
oraocci11.dll 1.26MB
oraocci11.dll 1.1MB
Oracle.DataAccess.dll 1.05MB
Oracle.DataAccess.dll 1.04MB
oci.dll 667KB
OraOLEDB11.dll 666KB
ociw32.dll 471KB
OraOps11w.dll 399KB
OraOps11w.dll 399KB
orasql11.dll 350KB
oramts11.dll 226KB
OraOLEDBrst11.dll 175KB
OraOledbIC11.dll 152KB
OraOLEDBgmr11.dll 140KB
ocijdbc11.dll 135KB
Oracle.Web.dll 104KB
Oracle.Web.dll 97KB
oramtsus.dll 64KB
omtsrecomsgus.dll 50KB
OraOLEDButl11.dll 19KB
OraOLEDBpus11.dll 15KB
Oracle.DataAccess.resources.dll 12KB
Oracle.DataAccess.resources.dll 12KB
oramts.dll 12KB
OraOLEDBrfc11.dll 11KB
Oracle.DataAccess.resources.dll 11KB
Oracle.DataAccess.resources.dll 11KB
Oracle.DataAccess.resources.dll 11KB
Oracle.Web.resources.dll 11KB
Oracle.DataAccess.resources.dll 11KB
Oracle.DataAccess.resources.dll 11KB
Oracle.DataAccess.resources.dll 11KB
Oracle.DataAccess.resources.dll 11KB
Oracle.DataAccess.resources.dll 11KB
Oracle.Web.resources.dll 11KB
Oracle.DataAccess.resources.dll 11KB
Oracle.Web.resources.dll 11KB
Oracle.DataAccess.resources.dll 11KB
Oracle.Web.resources.dll 11KB
Oracle.Web.resources.dll 11KB
Oracle.Web.resources.dll 11KB
Oracle.Web.resources.dll 11KB
Oracle.Web.resources.dll 11KB
Oracle.DataAccess.resources.dll 11KB
Oracle.DataAccess.resources.dll 11KB
Oracle.Web.resources.dll 11KB
Oracle.Web.resources.dll 11KB
OraOLEDB11e.dll 10KB
OraOLEDB11us.dll 10KB
OraOLEDBrmc11.dll 10KB
OraOLEDB11i.dll 10KB
OraOLEDB11d.dll 10KB
OraOLEDB11ptb.dll 10KB
OraOLEDB11f.dll 10KB
Oracle.Web.resources.dll 10KB
Oracle.Web.resources.dll 10KB
Oracle.Web.resources.dll 10KB
Oracle.Web.resources.dll 10KB
OraOLEDB11ko.dll 10KB
OraOLEDB11zhs.dll 10KB
OraOLEDB11ja.dll 10KB
OraOLEDB11zht.dll 10KB
omtsrecoevntf.dll 10KB
omtsrecoevnti.dll 10KB
omtsrecoevntus.dll 10KB
omtsrecoevntja.dll 10KB
omtsrecoevntptb.dll 10KB
omtsrecoevnte.dll 10KB
omtsrecoevntd.dll 10KB
Oracle.DataAccess.resources.dll 9KB
Oracle.DataAccess.resources.dll 9KB
Oracle.Web.resources.dll 9KB
Oracle.DataAccess.resources.dll 9KB
Oracle.DataAccess.resources.dll 9KB
Oracle.Web.resources.dll 9KB
omtsrecoevntko.dll 9KB
Oracle.Web.resources.dll 9KB
Oracle.Web.resources.dll 9KB
omtsrecoevntzht.dll 9KB
omtsrecoevntzhs.dll 9KB
Policy.4.112.Oracle.DataAccess.dll 3KB
Policy.4.112.Oracle.Web.dll 3KB
Policy.2.102.Oracle.DataAccess.dll 3KB
Policy.2.111.Oracle.DataAccess.dll 3KB
共 195 条
- 1
- 2
资源评论
- 余青葭2023-07-26这个文件提供了SQL SERVER安装ORACLE provider for OLE DB所需的连接服务驱动。非常方便实用,能够轻松实现两种数据库的连接。
- 高中生资讯2023-07-26这个文件的功能非常强大,我不仅成功地实现了SQL SERVER和ORACLE数据库的连接,还能够高效地进行数据读写操作。非常值得推荐!
- 林书尼2023-07-26使用这个文件,我成功地将SQL SERVER和ORACLE数据库连接在一起,实现了数据的传输和共享。非常实用!
- 仙夜子2023-07-26这个文件能够解决SQL SERVER连接ORACLE数据库的问题,非常适合需要在不同数据库之间进行数据交互的开发者使用。
- 稚气筱筱2023-07-26这个文件的安装步骤简洁明了,我按照说明一步步操作就顺利完成了SQL SERVER和ORACLE数据库的连接。
weixin_38746387
- 粉丝: 332
- 资源: 1308
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
最新资源
- STM32单片机FPGA毕设电路原理论文报告一种基于单片机的节能断电保护电路设计
- STM32单片机FPGA毕设电路原理论文报告一种基于单片机的机床位移检测系统
- unity3D翻书插件
- STM32单片机FPGA毕设电路原理论文报告一种基于单片机的红外测控系统
- Date(1).cpp
- java基于ssm珠宝商城购物网站案例设计
- STM32单片机FPGA毕设电路原理论文报告一种基于单片机的灯光调光控制系统开发
- STM32单片机FPGA毕设电路原理论文报告一种基于单片机的超声测距系统的设计
- Visual Basic快速入门.md
- STM32单片机FPGA毕设电路原理论文报告一种基于单片机的半导体激光器电源控制系统的设计
资源上传下载、课程学习等过程中有任何疑问或建议,欢迎提出宝贵意见哦~我们会及时处理!
点击此处反馈
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功