项目中,需要用 net 连接 远程 ORACLE 数据库, 连接字符串 怎么写??急!!!!
给一个例子。该ORACLE ip地址为 : ip: 10.225.109.204;我写的connstring="Data Source=**;User Id=DEV;Password=**;" 报错:System.Data.OracleClient.OracleException: ORA-12154: TNS:could not resolve service name at System.Data.OracleClient.OracleException.Check(OciErrorHandle errorHandle, Int32 rc)
给一个例子。该ORACLE ip地址为 : ip: 10.225.109.204;我写的connstring="Data Source=**;User Id=DEV;Password=**;" 报错:System.Data.OracleClient.OracleException: ORA-12154: TNS:could not resolve service name at System.Data.OracleClient.OracleException.Check(OciErrorHandle errorHandle, Int32 rc)
C:\orahome92\NETWORK\ADMIN\tnsnames.ora用记事本打开,输入如下信息:
myOracle =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = Oracle服务器的IP)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = Oracle的服务名)
)
)然后就可以这么用了:
connstring="server=myOracle;uid=DEV;pwd=**;"