我现在用的是.NET框架System.Data.OracleClient命名空间。我有预言11客户端安装在我的计算机上。我不希望使用tnsnames.ora文件来存储连接信息。

I am using the .NET framework with the System.Data.OracleClient namespace. I have the oracle 11 client installed on my computer. I do not want to use the tnsnames.ora file to store connection information.

可能有人请告诉我的连接字符串是什么样子，如果我不希望使用tnsnames.ora文件？我要存储的连接字符串中的Web应用程序项目的web.config文件。

Could someone please tell me what the connection string would look like if I did not want to use the tnsnames.ora file? I will be storing the connection string in a web.config file of a Web Application Project.

推荐答案

http://www.connectionstrings.com/oracle

这是一个很好的资源

SERVER=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=MyHost)(PORT=MyPort))(CONNECT_DATA=(SERVICE_NAME=MyOracleSID)));uid=myUsername;pwd=myPassword;

SERVER=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=MyHost)(PORT=MyPort))(CONNECT_DATA=(SERVICE_NAME=MyOracleSID)));uid=myUsername;pwd=myPassword;

是你要我相信...