mistacadogan

Hi Guys,
I currently have a Server 2003 machine that hosts some .Net applications that hit an Oracle 9i Database, however despite having all the necessary things in place for this to work, it doesn't.

By necessary things i mean, the tnsnames file is properly configured and i can actually access the database from the SQL+ on the Server 2K3 machine and all, however when it comes to the application actually communicating with the machine.......it never works. The funny thing is that when i deploy the same application(s) on an Server 2000 machine, it works fine.

Have you guys ever experienced this before? Please help me...

Kevin

Here's the error i keep getting.


Server Error in '/sapmmweb' Application.
--------------------------------------------------------------------------------

Oracle error occurred, but error message could not be retrieved from Oracle.
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.OleDb.OleDbException: Oracle error occurred, but error message could not be retrieved from Oracle.

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:


[OleDbException (0x80004005): Oracle error occurred, but error message could not be retrieved from Oracle.]
System.Data.OleDb.OleDbConnection.ProcessResults(Int32 hr) +20
System.Data.OleDb.OleDbConnection.InitializeProvider() +57
System.Data.OleDb.OleDbConnection.Open() +203
SAPMM.WebForm1.btnRetrieveReport_Click(Object sender, EventArgs e) in C:\Documents and Settings\nahunt\VSWebCache\papebizdev02\nadine\sapmmweb\Default.aspx.vb:86
System.Web.UI.WebControls.Button.OnClick(EventArgs e) +108
System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +57
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +18
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33
System.Web.UI.Page.ProcessRequestMain() +1292




--------------------------------------------------------------------------------
Version Information: Microsoft .NET Framework Version:1.1.4322.2407; ASP.NET Version:1.1.4322.2407