ODBC Error

[Rajesh Candamourty]

Dear All,

Linking one of the tables in Access 2000 to Oracle using ODBC connection. I
created a DSN in every user m/c. In one system DSN creatrion was successful,
but when accessing the linked data in the form I got this error "Reserved
error (-7709); there is no message for this error." How do I solve this?

In another m/c I got an error while creating a DSN. Error msg: "The
Oracle(TM) client and networking components were not found. These components
are supplied by Oracle Corporation and are part of the Oracle Version 7.3
(or greater) client software installation. You will be unable to use this
driver until these components have been installed". What is that I need to
install?

Any help highly appreciated.

Thank you in advance.
Rajesh Candmaourty

 

[Rob Oldfield]

Bleaugh. The joy of attempting to connect to Oracle. It'd be worth
checking that the version of the Oracle client you have installed is the
same everywhere. And, if you have an SQL server, consider linking the
Oracle into that. I've found (although via .Net instead of Access) that
that gives you a more stable basis on which to work.

Outside of those ideas, I'd tend to suggest posting this problem to an
Oracle group.