适用于Oracle 11g Express Edition的ADO.NET连接字符串 [英] ADO.NET connect string for Oracle 11g Express Edition

问题描述

我正在尝试连接到Oracle 11g Expres Edition上的数据库.以下连接字符串不起作用:

I am trying to connect to a database on Oracle 11g Expres Edition. The following connect string is not working:

<br />
<add name="NCMS_ORACLE_CONNECTIONSTRING" connectionString="Data Source=127.0.0.1;Database=MYDB1;User Id=USER1;Password=PWD1;" providerName="System.Data.OracleClient"/><br />

以上所有参数都是正确的，我可以使用它们从Web界面登录.

我之前在Oracle 10g XE中使用了相同的设置，但是在11g XE中使用了类似WORKSPACE的新设置.因此，我创建了一个名为MYDB1的数据库工作区，并在其中创建了所有表.

请帮忙...
Srinivas

All the above parameters are correct and I can use them to login from the web interface.

I was using the same setup earlier with Oracle 10g XE, but with 11g XE there is a new setup like WORKSPACE. So, I created my database workspace called MYDB1 and created all the tables in that.

Please help...
Srinivas

推荐答案

这可能有帮助

http://www.connectionstrings.com/oracle [

this might help

http://www.connectionstrings.com/oracle[^]

仅定义IP地址对于Oracle来说还不够.您必须定义在TNSNAMES.ORA描述文件中定义的名称.通常，在XE安装程序中，这只是XE

Defining simply IP address isn''t enough for Oracle. You have to define a name that is defined in your TNSNAMES.ORA description file. Typically in XE installatoins this is simply XE

您是否尝试过 www.connectionstrings.com [ ^ ]?

Have you tried www.connectionstrings.com[^]?

这篇关于适用于Oracle 11g Express Edition的ADO.NET连接字符串的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！