Home » RDBMS Server » Networking and Gateways » ODBC in Oracle 8i
ODBC in Oracle 8i [message #128444] Mon, 18 July 2005 09:57 Go to next message
prepotency
Messages: 3
Registered: July 2005
Junior Member
Hi, just a new oracle user looking for a little help here. Please excuse my inexperience.

I am on a network running an Oracle 8i service called "CMSP". I want to be able to connect to cmsp from my workstation and be able to interface with the oracle database using microsoft access. I'm not sure how to set up the settings in the ODBC Administrator so that I can connect to the "readonlyORACLE" connection that the Access program requires. If I'm being unclear, please inquire further.

I guess my question is: is there a way for me to get 8i ODBC drivers so that I can connect to this service without installing the entire oracle program?

G
Re: ODBC in Oracle 8i [message #128595 is a reply to message #128444] Tue, 19 July 2005 11:23 Go to previous messageGo to next message
Steve Callan
Messages: 44
Registered: January 2004
Member
http://databasejournal.com/features/oracle/article.php/3358411

What does "without installing the entire oracle program" mean?

[Updated on: Tue, 19 July 2005 11:24]

Report message to a moderator

Re: ODBC in Oracle 8i [message #128608 is a reply to message #128595] Tue, 19 July 2005 13:58 Go to previous messageGo to next message
prepotency
Messages: 3
Registered: July 2005
Junior Member
Maybe I'm just comletely misguided but do I need to install Oracle software onto my PC in order to access the service from Access? I was hoping I could just install some ODBC drivers and go. The service is already being hosted by a server on my network named CMSP.

Is that clearer?
Re: ODBC in Oracle 8i [message #128654 is a reply to message #128608] Wed, 20 July 2005 00:38 Go to previous messageGo to next message
girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)
Senior Member
Yes, Oracle client software needs to be installed.

Regds
Girish
Re: ODBC in Oracle 8i [message #128774 is a reply to message #128654] Wed, 20 July 2005 09:50 Go to previous message
prepotency
Messages: 3
Registered: July 2005
Junior Member
I have the software to install the client but everytime I start to install it the installer just times out and crashes - is this a common problem?
Previous Topic: HOST STRING
Next Topic: OMS and intelligent agent
Goto Forum:
  


Current Time: Thu Nov 28 13:36:33 CST 2024