Home > Archive > MS Access Multiuser > April 2005 > ODBC Error









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author ODBC Error
Rajesh Candamourty

2005-04-06, 8:06 pm

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

2005-04-06, 8:06 pm

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.


"Rajesh Candamourty" <NoSpam@microsoft.com> wrote in message
news:%23tjWGOhOFHA.1396@TK2MSFTNGP10.phx.gbl...
> 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
>
>



Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com