RE: MS Access, ODBC & Oracle 9i

From: Khemmanivanh, Somckit <somckit.khemmanivanh_at_weyerhaeuser.com>
Date: Wed, 9 Aug 2006 14:21:02 -0700
Message-ID: <65C0D8935651CB4D96E97CEFAC5A12B9022F1A0E@wafedixm10.corp.weyer.pri>

 

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_at_dp7upbg.com] Sent: Wednesday, August 09, 2006 2:10 PM To: Khemmanivanh, Somckit; paul.baumgartel_at_credit-suisse.com; Oracle-L_at_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_at_weyerhaeuser.com]

	Sent: Wednesday, August 09, 2006 3:15 PM
	To: paul.baumgartel_at_credit-suisse.com; Roger Xu;
Oracle-L_at_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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Baumgartel, Paul

	Sent: Wednesday, August 09, 2006 1:04 PM
	To: 'Roger.Xu_at_dp7upbg.com'; Oracle-L_at_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_at_credit-suisse.com 
	www.credit-suisse.com 

		-----Original Message-----
		From: oracle-l-bounce_at_freelists.org


[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Roger Xu

		Sent: Wednesday, August 09, 2006 1:01 PM
		To: Oracle-L_at_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.

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Aug 09 2006 - 16:21:02 CDT