RE: MS Access, ODBC & Oracle 9i
- From: "Khemmanivanh, Somckit" <somckit.khemmanivanh@xxxxxxxxxxxxxxxx>
- To: "Roger Xu" <Roger.Xu@xxxxxxxxxxx>, <paul.baumgartel@xxxxxxxxxxxxxxxxx>, "Oracle-L@Freelists. Org \(E-mail\)" <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 9 Aug 2006 14:21:02 -0700
No 9i client needs to be installed...it will want a tnsnames.ora file --
which you can create for it. Define a system environment variable called
ORACLE_HOME and place the file in there (in the network/admin)
You can use the ODBC driver(s) that come with Access.
Thanks!
________________________________
From: Roger Xu [mailto:Roger.Xu@xxxxxxxxxxx]
Sent: Wednesday, August 09, 2006 2:10 PM
To: Khemmanivanh, Somckit; paul.baumgartel@xxxxxxxxxxxxxxxxx;
Oracle-L@Freelists. Org (E-mail)
Subject: RE: MS Access, ODBC & Oracle 9i
Does ODBC driver and/or Oracle 9i Client need to be installed first?
Thanks!
-----Original Message-----
From: Khemmanivanh, Somckit
[mailto:somckit.khemmanivanh@xxxxxxxxxxxxxxxx]
Sent: Wednesday, August 09, 2006 3:15 PM
To: paul.baumgartel@xxxxxxxxxxxxxxxxx; Roger Xu;
Oracle-L@Freelists. Org (E-mail)
Subject: RE: MS Access, ODBC & Oracle 9i
In MS Access it's File -> Get External Data -> Import (then
choose the ODBC Datasource option)
Thanks!
________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Baumgartel, Paul
Sent: Wednesday, August 09, 2006 1:04 PM
To: 'Roger.Xu@xxxxxxxxxxx'; Oracle-L@Freelists. Org (E-mail)
Subject: RE: MS Access, ODBC & Oracle 9i
Uh...very carefully?
But seriously...I imagine a technical person has to set up the
ODBC data source first.
Paul Baumgartel
CREDIT SUISSE
Information Technology
DBA & Admin - NY, KIGA 1
11 Madison Avenue
New York, NY 10010
USA
Phone 212.538.1143
paul.baumgartel@xxxxxxxxxxxxxxxxx
www.credit-suisse.com
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Roger Xu
Sent: Wednesday, August 09, 2006 1:01 PM
To: Oracle-L@Freelists. Org (E-mail)
Subject: MS Access, ODBC & Oracle 9i
Hi List,
How does a non-technical person access a 9i database in
MS Access via ODBC?
Thanks,
Roger Xu
This e-mail is intended solely for the person or entity
to which it is addressed and may contain confidential and/or privileged
information. Any review, dissemination, copying, printing or other use o
____________________________________________________________________
This email has been scanned for all viruses by the
MessageLabs Email Security System.
========================================================================
======
Please access the attached hyperlink for an important electronic
communications disclaimer:
http://www.credit-suisse.com/legal/en/disclaimer_email_ib.html
========================================================================
======
This e-mail is intended solely for the person or entity to which it is
addressed and may contain confidential and/or privileged information.
Any review, dissemination, copying, printing or other use o
____________________________________________________________________
This email has been scanned for all viruses by the MessageLabs Email
Security System.
Other related posts:
