ORA-12514: TNS:listener doesn't know of service requested

Question

Hi Everyone,

I have an issue on my .net 2.0 application.  I'm able to connect to the database and everything from my computer.  I publish my website and moved those files over to the webserver.  When I remotely connect to my webserver, i can go into the dos command and login to oracle using sqlplus.   I  I get teh following error:

ORA-12514: TNS:listener does not currently know of service requested in connect descriptor

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.OracleClient.OracleException: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor


Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

 

Stack Trace:

[OracleException (0x80131938): ORA-12514: TNS:listener does not currently know of service requested in connect descriptor

]

System.Data.OracleClient.OracleException.Check(OciErrorHandle errorHandle, Int32 rc) +84

System.Data.OracleClient.OracleInternalConnection.OpenOnLocalTransaction(String userName, String password, String serverName, Boolean integratedSecurity, Boolean unicode, Boolean omitOracleConnectionName) +688

System.Data.OracleClient.OracleInternalConnection..ctor(OracleConnectionString connectionOptions) +135

System.Data.OracleClient.OracleConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject) +37

System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) +28

System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject) +429

System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject) +70

System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) +512

System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +85

System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +102

System.Data.OracleClient.OracleConnection.Open() +34

userlist.login.btnSubmit_Click(Object sender, EventArgs e) +299

System.Web.UI.WebControls.Button.OnClick(EventArgs e) +105

System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +107

System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +7

System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +11

System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33

System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +5102

Thanks for the help in advance

---

Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.42