.NET and Oracle DB connection

[valont]

TESTED CONNECTION-WORKS FINE BUT RUNNING OF APPLICATION GIVE THE FOLLOWING ERROR: DATA FROM DB NOT DISPLAYED IN MY APPLICATION PLS HELP THNX.



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

Error while trying to retrieve text for error ORA-12154
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: Error while trying to retrieve text for error ORA-12154

Source Error:


Line 122:
Line 123: Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Line 124: OleDbDataAdapter1.Fill(DataSet21)
Line 125: DataGrid1.DataBind()
Line 126: End Sub


Source File: c:\inetpub\wwwroot\ORACLE_PDAFRS\WebForm3.aspx.vb Line: 124

Stack Trace:


[OleDbException (0x80004005): Error while trying to retrieve text for error ORA-12154]
System.Data.OleDb.OleDbConnection.ProcessResults(Int32 hr) +20
System.Data.OleDb.OleDbConnection.InitializeProvider() +57
System.Data.OleDb.OleDbConnection.Open() +130
System.Data.Common.DbDataAdapter.QuietOpen(IDbConnection connection, ConnectionState& originalState) +44
System.Data.Common.DbDataAdapter.Fill(Object data, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +98
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +77
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) +38
ORACLE_PDAFRS.WebForm3.Button1_Click(Object sender, EventArgs e) in c:\inetpub\wwwroot\ORACLE_PDAFRS\WebForm3.aspx.vb:124
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() +1263




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

[ggnanaraj]

Check this out...
http://www.able-consulting.com/dotne...ETDataProvider

HTH.

[ggnanaraj]

Check this out also:
http://www.siue.edu/~dbock/cmis460/O...Connection.htm

HTH.