Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: **HELP** Accessing Oracle Database through Excel without Oracle 8i

Re: **HELP** Accessing Oracle Database through Excel without Oracle 8i

From: TurkBear <noone_at_nowhere.com>
Date: Mon, 27 Aug 2001 11:59:53 -0500
Message-ID: <tvukotc1jgfpr6blinf65bv2uh6ccdmuhn@4ax.com>

Question InLine:

"Gary Dickinson" <gd_at_interchange.ubc.ca> wrote:

>Hello. I have a script that accesses data from an oracle database
>using SQL that is going to be used by people that don't have the oracle 8i
>client
>software. However, they can connect to the oracle database I'm refering to.

HOW? If they do not have the client installed, they cannot..

>Is there a .dll file I can download or method I can use that allows me to do
>this? Here is the reference I'm using (VBA).
>
>"Driver={Microsoft ODBC for Oracle};" & _
> "Server=ec.van.as02;" & _
> "Uid=user;" & _
> "Pwd=password;"
>
>All help will be greatly appreciated.
>
>Thanks
>
>Gary
>
>

More info please....
( As an aside: If possible, I would use a OLE DB DSN-Less connection - instead of ODBC)

-----= Posted via Newsfeeds.Com, Uncensored Usenet News =----- http://www.newsfeeds.com - The #1 Newsgroup Service in the World!  Check out our new Unlimited Server. No Download or Time Limits! -----== Over 80,000 Newsgroups - 19 Different Servers! ==----- Received on Mon Aug 27 2001 - 11:59:53 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US