Oracle-GridView Databind fails with error OCIEnvNlsCreate failed

Discussion in 'ASP .Net' started by sreejith.ram@gmail.com, Apr 24, 2006.

  1. Guest

    I did google & search in this group , but couldnt find any thing
    related to this.

    This is my first attempt to connect GridView to a Oracle database via
    SqlDataSource. I am receving error message "OCIEnvNlsCreate failed
    with return code -1 but error message text was not available"

    Any one seen this or anything similar? Thank you in advance for all
    tips,suggestions,advices & helps

    Stack Trace Below
    ********************************************************
    System.Exception was unhandled by user code
    Message="OCIEnvNlsCreate failed with return code -1 but error message
    text was not available."
    Source="System.Data.OracleClient"
    StackTrace:
    at System.Data.OracleClient.OciHandle..ctor(OciHandle
    parentHandle, HTYPE handleType, MODE ocimode, HANDLEFLAG handleflags)
    at System.Data.OracleClient.OciNlsEnvironmentHandle..ctor(MODE
    environmentMode)
    at System.Data.OracleClient.OCI.DetermineClientVersion()
    at
    System.Data.OracleClient.OracleInternalConnection.OpenOnLocalTransaction(String
    userName, String password, String serverName, Boolean
    integratedSecurity, Boolean unicode, Boolean omitOracleConnectionName)
    at
    System.Data.OracleClient.OracleInternalConnection..ctor(OracleConnectionString
    connectionOptions)
    at
    System.Data.OracleClient.OracleConnectionFactory.CreateConnection(DbConnectionOptions
    options, Object poolGroupProviderInfo, DbConnectionPool pool,
    DbConnection owningObject)
    at
    System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection
    owningConnection, DbConnectionPool pool, DbConnectionOptions options)
    at
    System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection
    owningObject)
    at
    System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection
    owningObject)
    at
    System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection
    owningObject)
    at
    System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection
    owningConnection)
    at
    System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection
    outerConnection, DbConnectionFactory connectionFactory)
    at System.Data.OracleClient.OracleConnection.Open()
    at System.Data.Common.DbDataAdapter.FillInternal(DataSet
    dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords,
    String srcTable, IDbCommand command, CommandBehavior behavior)
    at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32
    startRecord, Int32 maxRecords, String srcTable, IDbCommand command,
    CommandBehavior behavior)
    at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String
    srcTable)
    at
    System.Web.UI.WebControls.SqlDataSourceView.ExecuteSelect(DataSourceSelectArguments
    arguments)
    at System.Web.UI.DataSourceView.Select(DataSourceSelectArguments
    arguments, DataSourceViewSelectCallback callback)
    at System.Web.UI.WebControls.DataBoundControl.PerformSelect()
    at System.Web.UI.WebControls.BaseDataBoundControl.DataBind()
    at System.Web.UI.WebControls.GridView.DataBind()
    at ReportsEMEA_RepairReport.btnGetReport_Click(Object sender,
    EventArgs e) in
    c:\Inetpub\wwwroot\WEB\Reports\RepairReport.aspx.cs:line 55
    at System.Web.UI.WebControls.Button.OnClick(EventArgs e)
    at System.Web.UI.WebControls.Button.RaisePostBackEvent(String
    eventArgument)
    at
    System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String
    eventArgument)
    at System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler
    sourceControl, String eventArgument)
    at System.Web.UI.Page.RaisePostBackEvent(NameValueCollection
    postData)
    at System.Web.UI.Page.ProcessRequestMain(Boolean
    includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)


    * The connection & query works fine via SqlPlus
    * ASP.NET , IWAM_ & IUSER_ accounts have FULL (for testing) permission
    to Oracle\bin folder
    * I did restart webserver , reboot machine(!!!) .. but it didnt help.

    Thanks again for the helps

    Sreejith
    , Apr 24, 2006
    #1
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Juha Laiho
    Replies:
    0
    Views:
    525
    Juha Laiho
    Jul 30, 2003
  2. David Rudder
    Replies:
    0
    Views:
    392
    David Rudder
    Jul 30, 2003
  3. mharness
    Replies:
    2
    Views:
    454
  4. Michael
    Replies:
    0
    Views:
    214
    Michael
    Dec 29, 2003
  5. Feyruz
    Replies:
    4
    Views:
    2,131
    Sherm Pendley
    Oct 14, 2005
Loading...

Share This Page