Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Access MS SQL Server tables from Oracle 9i
StefanKapitza wrote:
> you need the following :
>
> a) a database which will access sql-Server (this is your solaris box)
> b) a box where your odbc driver lives with an Oracle listener
> c) your "hs" database (in this case sql-server)
>
> usually a and b are on the same box, but must not. You could use
> any box with an OS you have odbc drivers (b could be any box with
> oracle on it). The drawback is, you have on more point of failure.
>
> let a) point to the b) listener, configure HS on b) where the odbc is
> pointing to c).
OK, I think I am getting it. The HC Admin Guide pages 7-3 and 7-5 let me to believe that a) and b) *must* *always* be on the same machine.
Thorsten Received on Thu May 26 2005 - 01:43:27 CDT