from access to oracle

[Miikka Hamalainen]

Hi,

We have huge oracle database in my company.
I would like to make some queies using access. I've been trying to connect
access to this oracle db, but without any luck.
Do I need to have some oracle drivers?
We are using other program to get information from the db and we have
acquired drivers for that program.

Any help is appreciated.

Thanks,

Miipe

[MGFoster]

Miikka Hamalainen wrote:

Hi,

We have huge oracle database in my company.
I would like to make some queies using access. I've been trying to connect
access to this oracle db, but without any luck.
Do I need to have some oracle drivers?
We are using other program to get information from the db and we have
acquired drivers for that program.

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Yes, you need the Oracle ODBC driver, or the Oracle OLEDB driver. The
ODBC driver should be in the Drivers tab of the ODBC Data Source
Administrator (Control Panel > Administrative Tools). Go to this WEB
site for ODBC connection strings:

http://www.connectionstrings.com/

Read the ADO documentation for the OLEDB connection strings.

Once you've set up a connection you can use SQL Pass Through (SPT)
queries, using Oracle's SQL syntax, to retrieve data. Read the Access
articles on SPT queries for more info.
--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQwOLFYechKqOuFEgEQJq6wCfesRE27RvGxIYsFHJuU8FUB IbnTgAoLuH
GrB/nWIKL0xKvpwF8wonBKWL
=5mjM
-----END PGP SIGNATURE-----

[Tim Marshall]

Miikka Hamalainen wrote:

We have huge oracle database in my company.
I would like to make some queies using access. I've been trying to connect
access to this oracle db, but without any luck.
Do I need to have some oracle drivers?
We are using other program to get information from the db and we have
acquired drivers for that program.

Access is a truly wonderful reporting tool to use with Oracle. With
experience, you can also write extremely effective applications that
will also manipulate (ie inserts, updates, deletes, DDL) Oracle very well.

You need to use an ODBC driver and set up a sat source name or "DSN".
If you need help with this, write back - I have an old Powerpoint
presentation for the win98 environment (it's essentally the same for
winXP) I've sent to a lot of Oracle users in the past I can email you.

You have two choices for the ODBC driver. Access comes with a Microsoft
produced Oracle ODBC driver and your Oracle installation cd comes with a
driver.

I've always advised using the Oracle ODBC driver over the MS one but my
organization is still using Oracle 8i. Some of my colleagues who use
Access against Oracle elsewhere have found some difficulties with 10G
and it's ODBC driver - I forget exactly the complication. They found
the MS one worked around the problem.
--
Tim http://www.ucs.mun.ca/~tmarshal/
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "What's UP, Dittoooooo?" - Ditto