oracle无法解析连接字符串，请教

[ayoya]

            string StrConnection = "Server=127.0.0.1;Data Source=kagami;User ID=system;Password=kagami;";
            string strCommand = "SELECT id as 产品编号, name as 产品名字 FROM test";
            OracleConnection OraCon = new OracleConnection(StrConnection);
            try
            {
                OraCon.Open(); ///无法解析
                OracleCommand OraCommand = new OracleCommand(strCommand, OraCon);
                OracleDataReader Reader = OraCommand.ExecuteReader();
                while (Reader.Read())
                {
                    Console.WriteLine("产品编号:{0}, 产品名字:{1}", Reader[0], Reader[1]);
                }
            }
            finally
            {
                OraCon.Close();
            }

[fengqiao1999]

看看是不是连接字符串错了
试下这个吧

"Data Source=数据库名;Persist Security Info=True;User ID=用户名;Password=密码;Unicode=True";

[wuyq11]

本地ORACLE客户端配置
检查tnsnames.ora
sql plus中用户名、密码、数据库
是否与字符串一致

[Lucky_6Q]

[Quote=引用 2 楼 wuyq11 的回复:]
本地ORACLE客户端配置
检查tnsnames.ora
sql plus中用户名、密码、数据库
是否与字符串一致
[/Quote]推荐

[ayoya]

继续求助，还是搞不定，sqlplus,plsqldeverloper都可连接
tnsnames.ora:# tnsnames.ora Network Configuration File: E:\oracle\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

KAGAMI =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = YH)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = kagami)
)
)
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = YH)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)

EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)


我是连接本地安装的oracle 10g
Data Source=kagami;User ID=system;Password=kagami;Persist Security Info=True;Unicode=True
加不加server字段也没见效果

[wuxing2006]

Data Source=(DESCRIPTION=(ADDRESS_LIST= (ADDRESS=(PROTOCOL=TCP)(HOST=10.10.10.X)(PORT=1521)))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=监听名字)));User Id=*****;Password=*****;

[ayoya]

已解决。
刚发的是服务器端的，
客户端的tnsnames.ora
KAGAMI_127.0.0.1 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
(CONNECT_DATA =
(SID = kagami)
(SERVER = DEDICATED)
)
)
///
把Data Source=KAGAMI_127.0.0.1即可