ADO - accessing oracle

S

sarasta

I've got an interesting question :
I have prepared an excel form for users in our company to get externa
data from oracle database. I used ADO method. Standart way to ge
external data is when you describe a service provider in a connectio
string of the connection object. The connection string references th
connection object through any service provider drivers to oracle clien
on a local computer. The oracle client processes the sql strin
retrieves data from server on a remote computer and passes the dat
back to recordset object of my excel program. But there's a problem
not all users of our company have the oracle client installed. I
there's a way how, using ADO, to connect directly to oracle server on
REMOTE coumputer not through the oracle client ?
Thanks very much in advance
 
R

Rob van Gelder

As far as I'm aware, the only way to connect to Oracle is via SQLnet, which
an Oracle Client provides.

You might be able to use Web Services as another method for extracting
information. I can't be any more specific as I have no experience there.
 
T

Tony Barla

Just spoke to a guy here at work.
The best way he thinks, is to use odbc.
Oracle DB comes with a config management tool that helps manage these links.

HTH.
Al.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top