topic Re: Microsoft Access with Oracle database in Operating System - HP-UX

Microsoft Access with Oracle database

Nagarathinam — Wed, 05 Jun 2002 09:57:33 GMT

Hi Experts,
Can I use Microsoft Access as a client to Oracle Databse in HP-UX. If so, How it can be done?
Any help is most welcome.

Thanks in advance.

Naga

Re: Microsoft Access with Oracle database

harry d brown jr — Wed, 05 Jun 2002 10:22:25 GMT

Naga,

With ODBC:

http://www.orafaq.com/faqodbc.htm

live free or die
harry

Re: Microsoft Access with Oracle database

H.Merijn Brand (procura — Wed, 05 Jun 2002 11:08:37 GMT

And perl

DBI-1.24
DBD-ODBC
DBD-Oracle

I've done something similar, were I ran perl/DBD-ODBC on M$ platform and used ODBC to connect to both M$ Access database and Unify database on HP-UX. Worked like a charm

Re: Microsoft Access with Oracle database

bio_leon_1 — Wed, 05 Jun 2002 11:33:25 GMT

Install a oracle client first,so all compent you need are installed.

Re: Microsoft Access with Oracle database

Emilio Maneiro_1 — Thu, 06 Jun 2002 05:31:29 GMT

You must have SQLNet installed and a listener running in the database server. On the client side you got to install the SQLNet client and the ODBC driver for Oracle that comes with Oracle client software.

After that you have to define your Oracle database in the client's tnsnames.ora and create a ODBC link. Then you can link an oracle table in your access database and select, update, insert or delete data.

Emilio Maneiro.
Sevilla, Spain.

Re: Microsoft Access with Oracle database

Victor Geere — Thu, 06 Jun 2002 07:17:29 GMT

The above replies still apply.

In Access go about creating a new table, but when given the option select "Link Table". Select the ODBC source and Oracle table of your choice.

But...

If you want to link an Oracle database to Access for the same reason I did (to elegantly access an Oracle database running in some dark corner of your organisation) you might want to consider creating a linked server in MS SQL. This allows you to write transact SQL queries in query analyser directly against an Oracle database. If this is an option I'll send you the HowTo.