locked
error: No error message available, result code: E_UNEXPECTED(0x8000FFFF). RRS feed

  • Question

  • User1046245955 posted

    anyone got idea on how to solve this issue.

    No error message available, result code: E_UNEXPECTED(0x8000FFFF).
    Exception Details: System.Data.OleDb.OleDbException: No error message available, result code: E_UNEXPECTED(0x8000FFFF).

    [OleDbException (0x8000ffff): No error message available, result code: E_UNEXPECTED(0x8000FFFF).]
       System.Data.OleDb.OleDbConnectionInternal..ctor(OleDbConnectionString constr, OleDbConnection connection) +516
       System.Data.OleDb.OleDbConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject) +100
       System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup, DbConnectionOptions userOptions) +57
       System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection) +1226
       System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions) +318
       System.Data.ProviderBase.DbConnectionInternal.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +26
       System.Data.OleDb.OleDbConnection.Open() +55
       System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +177
       System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +182
       System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable) +123
       System.Web.UI.WebControls.SqlDataSourceView.ExecuteSelect(DataSourceSelectArguments arguments) +2964
       System.Web.UI.WebControls.ListControl.OnDataBinding(EventArgs e) +369
       System.Web.UI.WebControls.ListControl.PerformSelect() +43
       System.Web.UI.WebControls.BaseDataBoundControl.EnsureDataBound() +139
       System.Web.UI.WebControls.ListControl.OnPreRender(EventArgs e) +36
       System.Web.UI.Control.PreRenderRecursiveInternal() +110
       System.Web.UI.Control.PreRenderRecursiveInternal() +207
       System.Web.UI.Control.PreRenderRecursiveInternal() +207
       System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +2994


    Thursday, December 5, 2019 7:28 AM

All replies

  • User753101303 posted

    Hi,

    What is your underlying OleDb source and show maybe your connection string? If file based, is the file version supported by the provider you are using ?

    I would likely create a simple test app, opening myself the connection to ease test and changes until it works...

    Thursday, December 5, 2019 8:02 AM
  • User1046245955 posted

    here's my connectionstring

    <connectionStrings>
    <add name="oleconxn" connectionString="Provider=OraOleDb.Oracle;Data Source=PROD;Password=PSWD;User ID=UNAME" providerName="System.Data.OleDb"/>
    </connectionStrings>

    Thursday, December 5, 2019 9:50 AM
  • User364663285 posted

    Hi,

    Are you able to connect using same logon user and password?

    Please ensure you're fine to create SQLCommand and SQL OLE connection in your project.

    Monday, January 20, 2020 9:33 AM
  • User269602965 posted

    Connection string is

    Provider=OraOLEDB.Oracle;Data Source=PROD;User Id=UNAME;Password=PSWD;

    System.Data.OleDB was long ago deprecated for Oracle.

    Presumed you installed the Oracle OLE DB provider?

    If so, consider use of the Oracle Managed or Unmanaged .NET driver instead of OLEDB.

    Wednesday, January 22, 2020 2:25 AM