"Data Source=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=myServerName)(PORT=1521)))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=myServiceName))) User Id=myUserName Password=myPassword" The connection string is correctly formulated i.e.
I can also connect with no problems using ODBC (except I can't use ODBC because it causes other problems when accessed from ASP.NET). At the customer site with Oracle 10.1 Client the same code generates the 12154 error.Īt the customer site, I can connect without errors with the customer's connection information (Hostname, port, SID) using Navicat 8 Lite for Oracle and SQL-Plus. The code functions correctly on our internal (remote) database using the Oracle XE 10.2 Client. I am experiencing an ORA-12154 exception when accessing a remote Oracle database using ADO.NET called from c# code running on a Windows 2003 system.
0 kommentar(er)
