ADO - accessing oracle
 

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

ADO - accessing oracle
 

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

ADO - accessing oracle
 

Hi sarasta:

This might be a better site:

http://msdn.microsoft.com/newsgroups... ang=en&cr=US

Good Luck
TK


"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

ADO - accessing oracle
 

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.

"sarasta" wrote:


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