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

--
sarast
-----------------------------------------------------------------------
sarasta's Profile: http://www.excelforum.com/member.php...fo&userid=1095
View this thread: http://www.excelforum.com/showthread.php?threadid=26716