Microsoft OLE DB Provider for Oracle (0x80004005)
Oracle error occurred, but error message could not be retrieved from
Oracle.
What I've done so far:
1) Logged into the database and ran a simple query using SQL*Plus from
my PC, using the same connection string and id/pwd, to make sure I
could connect. -- Worked.
2) Checked Oracle registry settings. -- Looks like they're all
pointed to the right folder, but I'm not sure which specific keys
should be there.
3) Checked folder permissions. -- Gave the IUSR and the Authenticated
user permissions to read & execute on the ora92 folder and all
subfolders and files. Briefly tried giving same to Everyone, but
since it didn't seem to make a difference I removed it. Do I need to
give permissions to any other user?
4) Created environment variables ORACLE_HOME and OraHome92, both
pointing to the Ora92 directory.
None of the above have made any difference. Help?
-- Kris