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.

--
Rob van Gelder - http://www.vangelder.co.nz/excel


"sarasta" wrote in message
...

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


--
sarasta
------------------------------------------------------------------------
sarasta's Profile:
http://www.excelforum.com/member.php...o&userid=10956
View this thread: http://www.excelforum.com/showthread...hreadid=267167