Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Oracle connection failing

0 views
Skip to first unread message

Kris

unread,
Feb 27, 2007, 6:21:01 PM2/27/07
to
I am pulling an existing, working website down from the dev server to
my PC to work on it. Everything's working except the Oracle 9i
MSDAORA connection. The first time I open the connection string, I
get this error:

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

0 new messages