Connection between Acess and Oracle

[DBC]

Hello,
Who knows how I can connect an Acces Database to an Oracle Database

Hans de Best
dbc@home.n;l

[Mark C. Stock]

"DBC" <dbc@home.nl> wrote in message
news:d389pb$9lm$1@news5.zwoll1.ov.home.nl... Hello, Who knows how I can connect an Acces Database to an Oracle Database Hans de Best dbc@home.n;l

ODBC
linked tables

++ mcs

[IANAL_VISTA]

"DBC" <dbc@home.nl> wrote in news:d389pb$9lm$1@news5.zwoll1.ov.home.nl:
Hello, Who knows how I can connect an Acces Database to an Oracle Database
Use PERL

[Mark C. Stock]

"IANAL_VISTA" <IANAL_Vista@hotmail.com> wrote in message
news:Xns96333F3E1D19ASunnySD@68.6.19.6... "DBC" <dbc@home.nl> wrote in news:d389pb$9lm$1@news5.zwoll1.ov.home.nl: Hello, Who knows how I can connect an Acces Database to an Oracle Database Use PERL

between Access and Oracle?

i guess the question is, does the OP want to use Access as the GUI to
Oracle, or does the OP want to use both Access and Oracle as back-ends

++ mcs

[Rauf Sarwar]

DBC wrote: Hello, Who knows how I can connect an Acces Database to an Oracle Database Hans de Best dbc@home.n;l

Very simple. Launch Access, Click on Help then type Oracle in the
search.

Regards
/Rauf

[John]

DBC wrote: Hello, Who knows how I can connect an Acces Database to an Oracle Database Hans de Best dbc@home.n;l
Be a little more specific on what the needs are...ie Access front end
with Oracle tables, tables in both Access and Oracle?

[Daniel Morgan]

GS wrote: DBC wrote: Hello, Who knows how I can connect an Acces Database to an Oracle Database Hans de Best dbc@home.n;l Be a little more specific on what the needs are...ie Access front end with Oracle tables, tables in both Access and Oracle?

And versions. But basically ODBC. And don't use the Microsoft drivers.

--
Daniel A. Morgan
University of Washington
damorgan@x.washington.edu
(replace 'x' with 'u' to respond)

[Michael Squires]

I've been trying to use ODBC to connect Access (2000 and later) to a 10g
RAC; so far the only 10g network stack that has worked reliably has been
the Instant Client. None of the 10g standard clients, including .2 with
the .3 patchset, has worked.

(The IC I've used has been the .3 version from Oracle's OTN web site)

The 9i client worked fine, but there are apparently issues with database
corruption caused by using a 9i client with at least a v .2 10g RAC server,
so I've been told (ordered?) to not do that any more.

Failure is defined as being able to connect to a table in Access but having
all the cells filled wiht "#DELETED", which is apparently a problem with
converting Oracle variable types to Access types, according to an old MS
KB entry describing a similar problem with Access 97 and Oracle 8i.

Mike Squires

--

Mike Squires (mikes at cs.indiana.edu) 317 233 9456 (w) 812 333 6564 (h)
mikes at siralan.org 546 N Park Ridge Rd., Bloomington, IN 47408

[Daniel Morgan]

Michael Squires wrote: I've been trying to use ODBC to connect Access (2000 and later) to a 10g RAC; so far the only 10g network stack that has worked reliably has been the Instant Client. None of the 10g standard clients, including .2 with the .3 patchset, has worked. (The IC I've used has been the .3 version from Oracle's OTN web site) The 9i client worked fine, but there are apparently issues with database corruption caused by using a 9i client with at least a v .2 10g RAC server, so I've been told (ordered?) to not do that any more. Failure is defined as being able to connect to a table in Access but having all the cells filled wiht "#DELETED", which is apparently a problem with converting Oracle variable types to Access types, according to an old MS KB entry describing a similar problem with Access 97 and Oracle 8i. Mike Squires

RAC is irrelevant to the conversation though the problem may well be in
your TNSNAMES.ORA confusing what is a database (you never connect to a
database) and what is an instance (you always connect to an instance).

Perhaps your ODBC driver is not Oracle's and is too stupid to know the
difference.
--
Daniel A. Morgan
University of Washington
damorgan@x.washington.edu
(replace 'x' with 'u' to respond)

[mAsterdam]

IANAL_VISTA wrote:

Use PERL

That would be either perl or Perl, but no scream.