469,900 Members | 1,714 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,900 developers. It's quick & easy.

from access to oracle

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
Nov 13 '05 #1
2 1540
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-----
Nov 13 '05 #2
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
Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by Jon Ole Hedne | last post: by
11 posts views Thread by Rosco | last post: by
2 posts views Thread by egoldthwait | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.