Oracle.ManagedDataAccess NuGet Package 21.14.0 README
=====================================================
Release Notes: Oracle Data Provider for .NET, Managed Driver
April 2024
This README supplements the main ODP.NET 21c documentation.
https://docs.oracle.com/en/database/oracle/oracle-database/21/odpnt/
TABLE OF CONTENTS
*Bug Fixes
*Installation and Configuration Steps
*Installation Changes
*Documentation Corrections and Additions
*ODP.NET, Managed Driver Tips, Limitations, and Known Issues
Bug Fixes since Oracle.ManagedDataAccess NuGet Package 21.13.0
==============================================================
Bug 36120362 - HIT "ORA-01008" OR "ORA-01722" WHEN EXECUTE QUERY STATEMENT WITH COMMENTS INCLUDING SINGLE QUOTE AND BINDBYNAME = TRUE
Installation and Configuration Steps
====================================
The downloads are NuGet packages that can be installed with the NuGet Package Manager. These instructions apply
to install ODP.NET, Managed Driver.
1. Un-GAC and un-configure any existing assembly (i.e. Oracle.ManagedDataAccess.dll) and policy DLL
(i.e. Policy.4.122.Oracle.ManagedDataAccess.dll) for the ODP.NET, Managed Driver, version 4.122.21.1
that exist in the GAC. Remove all references of Oracle.ManagedDataAccess from machine.config file, if any exists.
2. In Visual Studio, open NuGet Package Manager from an existing Visual Studio project.
3. Install the NuGet package from NuGet Gallery (nuget.org).
From Local Package Source
-------------------------
A. Click on the Settings button in the lower left of the dialog box.
B. Click the "+" button to add a package source. In the Source field, enter in the directory location where the
NuGet package(s) were downloaded to. Click the Update button, then the Ok button.
C. On the left side, under the Online root node, select the package source you just created. The ODP.NET NuGet
packages will appear.
From Nuget.org
--------------
A. In the Search box in the upper right, search for the package with id, "Oracle.ManagedDataAccess". Verify
that the package uses this unique ID to ensure it is the official Oracle Data Provider for .NET, Managed Driver
download.
B. Select the package you wish to install.
4. Click on the Install button to select the desired NuGet package(s) to include with the project. Accept the
license agreement and Visual Studio will continue the setup.
5. Open the app/web.config file to configure the ODP.NET connection string and connect descriptors.
Below is an example of configuring the net service aliases and connect descriptors parameters:
<oracle.manageddataaccess.client>
<version number="*">
<dataSources>
<!-- Customize these connection alias settings to connect to Oracle DB -->
<dataSource alias="MyDataSource" descriptor="(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=ORCL))) " />
</dataSources>
</version>
</oracle.manageddataaccess.client>
After following these instructions, ODP.NET is now configured and ready to use.
IMPORTANT: Oracle recommends configuring net service aliases and connect descriptors in a .NET config file to
have the application configuration be self-contained rather than using tnsnames.ora or TNS_ADMIN.
NOTE: ODP.NET, Managed Driver comes with one set of platform specific assemblies for Kerberos support: Oracle.ManagedDataAccessIOP.dll.
The Oracle.ManagedDataAccessIOP.dll assembly is ONLY needed if you are using Kerberos5 based external
authentication. Kerberos5 users will need to download MIT Kerberos for Windows version 4.0.1 from
https://web.mit.edu/kerberos/dist/
to utilize ODP.NET, Managed Driver's support of Kerberos5.
The asssemblies are located under
packages\Oracle.ManagedDataAccess.<version>\bin\x64
and
packages\Oracle.ManagedDataAccess.<version>\bin\x86
depending on the platform.
If these assemblies are required by your application, your Visual Studio project requires additional changes.
Use the following steps for your application to use the 64-bit version of Oracle.ManagedDataAccessIOP.dll:
1. Right click on the Visual Studio project.
2. Select Add -> New Folder.
3. Name the folder x64.
4. Right click on the newly created x64 folder.
5. Select Add -> Existing Item.
6. Browse to packages\Oracle.ManagedDataAccess.<version>\bin\x64 under your project solution directory.
7. Choose Oracle.ManagedDataAccessIOP.dll.
8. Click the 'Add' button.
9. Left click the newly added Oracle.ManagedDataAccessIOP.dll in the x64 folder.
10. In the properties window, set 'Copy To Output Directory' to 'Copy Always'.
For x86 targeted applications, name the folder x86 and add assemblies from the
packages\Oracle.ManagedDataAccess.<version>\bin\x86 folder.
To make your application platform independent even if it depends on Oracle.ManagedDataAccessIOP.dll, create both x64 and x86 folders with the necessary assemblies added to them.
Installation Changes
====================
The following app/web.config entries are added by including the ODP.NET, Managed Driver NuGet package to your application:
1) Configuration Section Handler
The following entry is added to the app/web.config to enable applications to add an <oracle.manageddataaccess.client>
section for ODP.NET, Managed Driver-specific configuration:
<configuration>
<configSections>
<section name="oracle.manageddataaccess.client" type="OracleInternal.Common.ODPMSectionHandler, Oracle.ManagedDataAccess, Version=4.122.21.1, Culture=neutral, PublicKeyToken=89b483f429c47342" />
</configSections>
</configuration>
Note: If your application is a web application and the above entry was added to a web.config and the same config
section handler for "oracle.manageddataaccess.client" also exists in machine.config but the "Version" attribute values
are different, an error message of "There is a duplicate 'oracle.manageddataaccess.client' section defined." may be
observed at runtime. If so, the config section handler entry in the machine.config for
"oracle.manageddataaccess.client" has to be removed from the machine.config for the web application to not encounter
this error. But given that there may be other applications on the machine that depended on this entry in the
machine.config, this config section handler entry may need to be moved to all of the application's .NET config file on
that machine that depend on it.
2) DbProviderFactories
The following entry is added for applications that use DbProviderFactories and DbProviderFactory classes. Also, any
DbProviderFactories entry for "Oracle.ManagedDataAccess.Client" in the machine.config will be ignored with the following
entry:
<configuration>
<system.data>
<DbProviderFactories>
<remove invariant="Oracle.ManagedDataAccess.Client" />
<add name="ODP.NET, Managed Driver" invariant="Oracle.ManagedDataAccess.Client" description="Oracle Data Provider for .NET, Managed Driver" type="Oracle.ManagedDataAccess.Client.OracleClientFactory, Oracle.ManagedDataAccess, Version=4.122.21.1, Culture=neutral, PublicKeyToken=89b483f429c47342" />
</DbProviderFactories>
</system.data>
</configuration>
3) Dependent Assembly
The following entry is created to ignore policy DLLs for Oracle.ManagedDataAccess.dll and always use the
Oracle.ManagedDataAccess.dll version that is specified by the newVersion attribute in the <bindingRedirect> element.
The newVersion attribute corresponds to the Oracle.ManagedDataAccess.dll version which came with the NuGet package
associated with the application.
<configuration>
<runtime>
<assemblyBinding xmlns="urn:schemas-microsoft-com:asm.v1">
<dependentAssembly>
<publisherPolicy apply="no" />
<assemblyIdentity name="Oracle.ManagedDataAccess" public
没有合适的资源?快使用搜索试试~ 我知道了~
c# webservice 使用http向服务器传输数据
共324个文件
dll:91个
_:59个
xml:56个
需积分: 0 0 下载量 153 浏览量
2024-05-07
16:58:17
上传
评论
收藏 13.1MB ZIP 举报
温馨提示
c# webservice 使用http向服务器传输数据
资源推荐
资源详情
资源评论
收起资源包目录
c# webservice 使用http向服务器传输数据 (324个子文件)
_._ 0B
_._ 0B
_._ 0B
_._ 0B
_._ 0B
_._ 0B
_._ 0B
_._ 0B
_._ 0B
_._ 0B
_._ 0B
_._ 0B
_._ 0B
_._ 0B
_._ 0B
_._ 0B
_._ 0B
_._ 0B
_._ 0B
_._ 0B
_._ 0B
_._ 0B
_._ 0B
_._ 0B
_._ 0B
_._ 0B
_._ 0B
_._ 0B
_._ 0B
_._ 0B
_._ 0B
_._ 0B
_._ 0B
_._ 0B
_._ 0B
_._ 0B
_._ 0B
_._ 0B
_._ 0B
_._ 0B
_._ 0B
_._ 0B
_._ 0B
_._ 0B
_._ 0B
_._ 0B
_._ 0B
_._ 0B
_._ 0B
_._ 0B
_._ 0B
_._ 0B
_._ 0B
_._ 0B
_._ 0B
_._ 0B
_._ 0B
_._ 0B
_._ 0B
WindowsFormsApp17.csproj.AssemblyReference.cache 18KB
DesignTimeResolveAssemblyReferencesInput.cache 8KB
DesignTimeResolveAssemblyReferences.cache 2KB
WindowsFormsApp17.csproj.GenerateResource.cache 126B
WindowsFormsApp17.csproj.CoreCompileInputs.cache 42B
WindowsFormsApp17.csproj.SuggestedBindingRedirects.cache 0B
App.config 2KB
WindowsFormsApp17.exe.config 2KB
packages.config 990B
WindowsFormsApp17.csproj.CopyComplete 0B
Form1.Designer.cs 14KB
Form1.cs 10KB
Resources.Designer.cs 3KB
AssemblyInfo.cs 1KB
Settings.Designer.cs 1KB
Program.cs 538B
.NETFramework,Version=v4.8.AssemblyAttributes.cs 210B
WindowsFormsApp17.csproj 8KB
Oracle.ManagedDataAccess.dll 4.53MB
Oracle.ManagedDataAccess.dll 4.53MB
System.Text.Json.dll 501KB
System.Text.Json.dll 501KB
System.Text.Json.dll 499KB
System.Text.Json.dll 497KB
System.Text.Json.dll 447KB
Oracle.ManagedDataAccessIOP.dll 268KB
Oracle.ManagedDataAccessIOP.dll 229KB
System.Numerics.Vectors.dll 160KB
System.Numerics.Vectors.dll 157KB
System.Numerics.Vectors.dll 157KB
System.Text.Json.SourceGeneration.dll 145KB
System.Text.Json.SourceGeneration.dll 144KB
System.Memory.dll 139KB
System.Memory.dll 139KB
System.Memory.dll 139KB
System.Memory.dll 135KB
System.Numerics.Vectors.dll 113KB
System.Numerics.Vectors.dll 113KB
System.Formats.Asn1.dll 101KB
System.Formats.Asn1.dll 101KB
System.Formats.Asn1.dll 101KB
共 324 条
- 1
- 2
- 3
- 4
资源评论
byftuyk
- 粉丝: 0
- 资源: 2
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功