Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: Using Access as a client
"Joseph Ranseth" <jransethNO_SPAM_at_hotmail.com> allegedly wrote:
> I have a development server setup in our office, and have a few develpoment
> clients accessing it already.
>
> What I need now is to setup one of our end users to the developement DB in
> order to run an insert query from an access interface. This isn't a problem
> on the development boxes, b/c they have the oracle odbc drivers installed
> already - the end-user with only access does not.
> Windows(or access) comes with an oracle driver, but for some reason it
> doesn't want to find the service when I try to create the DSN.
> I tried downloading drivers from oracle.com, but they assume that client
> tools are already installed.
>
> Any ideas what could be wrong, or what I need to do/create in order to make
> everything run smoothly?
*Any* Oracle ODBC driver you find is going to want the Oracle Client software installed.
So, pop in your Oracle CD on that Access machine and install just the Oracle Client.
-- Chris Kasten icq# 7603936 http://www.kastenracing.com/chris/Received on Fri Jan 19 2001 - 19:49:39 CST