Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: **HELP** Accessing Oracle Database through Excel without Oracle 8i
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