Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Oracle and MS Access

Re: Oracle and MS Access

From: <andragon_at_my-deja.com>
Date: Tue, 16 Nov 1999 09:37:52 GMT
Message-ID: <80r8lg$kgp$1@nnrp1.deja.com>


In article <80mnbe$fv1$1_at_news1.xs4all.nl>,   "HJ" <dancing_at_dds.nl> wrote:
> Hi all,
>
> I'm searching for information on how to connect
to an Oracle database from a
> Microsoft Access application. Does that require
an ODBC connection? Can I
> link tabels of an Oracle database into an
Access application?

Hi,

you need the SQL-NetClient and the ODBC-driver from Oracle on your client machine. If your Oracle server is not on the same machine as your Access application, you will first have to create a network alias using SQL-NetEasyConfiguration. Then start Access. Open or create your Database. Create a new table as a link (do not import a table). You get an open file dialog window. Change file type from "Access" to "ODBC- Databases" and you see the dialog changes into "Choose Datasource" dialog. Here you can select a datasource, if one already exists and matches your needs, or create a new one. If you are in doubt, do create a new dsn. If you create a new dsn (make shure you create a computer dsn). It is no matter wether you create a system or user dsn. You get to choose the ODBC-driver, so choose the Oracle driver you previously installed (hopefiully it is fom Oracle 7.3.3 or 8.0.5). After the finish you must setup the connection parameters. Choose a clear name for your dsn, the description is as you like, the SQL*Net Connect String is "2:" for a local database or your network-alias created with EasyConfiguration earlier for remote databases. You are then about to be connected to Oracle and must provide a valid user name and password for Oracle. If successful, you get a list of all accessible tables. Tables of the user schema appear with the user na,e in front. Take your pick and click ok. You then might get asked for the column(s) that represent the primary key.

By the way: you can send SQL to Oracle
through "Pass-Through queries".

Any more questions mail me.

Andreas

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Nov 16 1999 - 03:37:52 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US