No error message available, result code: E_UNEXPECTED(0x8000FFFF). Exception Details:System.Data.OleDb.OleDbException: No error message available, result code: E_UNEXPECTED(0x8000FFFF).
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...
Member
31 Points
296 Posts
error: No error message available, result code: E_UNEXPECTED(0x8000FFFF).
Dec 05, 2019 07:28 AM|paminchever|LINK
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).
All-Star
48570 Points
18082 Posts
Re: error: No error message available, result code: E_UNEXPECTED(0x8000FFFF).
Dec 05, 2019 08:02 AM|PatriceSc|LINK
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...
Member
31 Points
296 Posts
Re: error: No error message available, result code: E_UNEXPECTED(0x8000FFFF).
Dec 05, 2019 09:50 AM|paminchever|LINK
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>
Contributor
6479 Points
5815 Posts
Re: error: No error message available, result code: E_UNEXPECTED(0x8000FFFF).
Jan 20, 2020 09:33 AM|wmec|LINK
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.
Peter
Contributor
3482 Points
1343 Posts
Re: error: No error message available, result code: E_UNEXPECTED(0x8000FFFF).
Jan 22, 2020 02:25 AM|Lannie|LINK
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.