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