.Net链接Oracle必须是TnsName么？

hnlht018

听别人介绍说最简单的方式就是装上ORACLE的客户端，
也不是很清楚

赵宇

请大家看看这个第三方组件
http://down.qn165.com/view.asp?id=144


Oracle 的 .NET Framework 資料提供者
Oracle 的 .NET Framework 資料提供者透過 Oracle 用戶端連接軟體啟用對 Oracle 資料來源的資料存取。資料提供者支援 Oracle 用戶端軟體 8.1.7 (含) 以後版本。資料提供者支援本機和分散式交易 (資料提供者會自動登記在現有的分散式交易中，但目前並不支援 EnlistDistributedTransaction 方法)。如需詳細資訊，請參閱執行交易。

Oracle 的 .NET Framework 資料提供者需要您在使用它之前先在系統上安裝 Oracle 用戶端軟體 (8.1.7 (含) 以後版本)，以便連接到 Oracle 資料來源。

Oracle 的 .NET Framework 資料提供者類別位於 System.Data.OracleClient 命名空間，並包含於 System.Data.OracleClient.dll 組件 (Assembly)。如果您要編譯的應用程式有使用資料提供者，則必須參考 System.Data.dll 和 System.Data.OracleClient.dll。

注意 Oracle 的 .NET Framework 資料提供者沒有隨附在 .NET Framework 1.0 版中。如果您需要 Oracle 的 .NET Framework 資料提供者，而且正使用 .NET Framework 1.0 版，您可以下載 Oracle 的 .NET Framework 資料提供者，網址為 http://msdn.microsoft.com/downloads。
下列程式碼範例顯示如何將 System.Data.SqlClient 命名空間納入您的應用程式。

[Visual Basic]
Imports System.Data.OracleClient
[C#]
using System.Data.OracleClient;

赵宇

Oracle 9i Client and System.Data.OracleClient

If you haven't yet upgraded to a newer Oracle client (e.g. 9.2) or you are having problems with your current Oracle client (9i or higher) then you will need to take a few steps to make your client work as you might expect.  There are two main considerations:

TNSNAMES.ORA must be local
Permissions must be reset on your client directory
tnsnames.ora
Typically, companies will centralize the tnsnames.ora files (used for resolving Oracle service names) but putting it on a fileserver and pointing to it in the registry.  This works just fine for Oracle's toolset and many other client programs with the exception of the System.Data.OracleClient ADO.Net provider.  The provider, for some reason, expects this file to be installed locally (example: c:\oracle\ora92...\tnsnames.ora).  Installing (and perhaps mirroring from a network share) locally will take care of the first requirement.

Permissions
For some reason, the permissions for the "Authenticated Users" user is not fully propagated throughout the Oracle client install.  The fix for this is straightforward as well:

Open Explorer to your client install directory (c:\oracle\ora92)
Right-click ora92 and select propertied
Select the "Security" tab
Select the "Authenticated Users" entry
Uncheck the "Read and Execute" attribute
Click Apply
Re-check the "Read and Execute" attribute
Click Ok
Reset IIS

charles_gao

看来还是有点麻烦，不像Java那么简单！

rainbow

最初由 赵宇 发布
[B]Oracle 9i Client and System.Data.OracleClient

If you haven't yet upgraded to a newer Oracle client (e.g. 9.2) or you are having problems with your current Oracle client (9i or higher) then you will need to take a few steps to make your client work as you might expect.  There are two main considerations:

TNSNAMES.ORA must be local
Permissions must be reset on your client directory
tnsnames.ora
Typically, companies will centralize the tnsnames.ora files (used for resolving Oracle service names) but putting it on a fileserver and pointing to it in the registry.  This works just fine for Oracle's toolset and many other client programs with the exception of the System.Data.OracleClient ADO.Net provider.  The provider, for some reason, expects this file to be installed locally (example: c:\oracle\ora92...\tnsnames.ora).  Installing (and perhaps mirroring from a network share) locally will take care of the first requirement.

Permissions
For some reason, the permissions for the "Authenticated Users" user is not fully propagated throughout the Oracle client install.  The fix for this is straightforward as well:

Open Explorer to your client install directory (c:\oracle\ora92)
Right-click ora92 and select propertied
Select the "Security" tab
Select the "Authenticated Users" entry
Uncheck the "Read and Execute" attribute
Click Apply
Re-check the "Read and Execute" attribute
Click Ok
Reset IIS [/B]

我当时就遇到了这个问题，文件系统是NTFS，.Net如何都不能找到TnsNames.ora，而在FAT32上就没有问题，后来查过后，发现是NTFS文件系统的权限设置问题，忙乎了一下，后来就OK了。

okone96

study

cuilinny

vs2005上有2.0版本

charles_gao

最初由 cuilinny 发布
[B]vs2005上有2.0版本 [/B]

没看明白，什么意思？

lxchutao

charles_gao 发表于 2006-4-5 09:56
老兄，你没有看清标题吧？
我们讨论的是不用tnsname.ora的情况！

(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.10.247)(PORT = 1521)))(CONNECT_DATA = (SERVICE_NAME = ORCL)))
没错的Plsql developer  的数据库那栏写成这样就OK了

lxchutao

这时即使不没有安装Oracle客户端也是可以连接的