Re: Access MS SQL Server tables from Oracle 9i

Thorsten Jens wrote:
> angsql_at_gmail.com schrieb:
> > Try this
> >
> >
> http://www.databasejournal.com/features/oracle/article.php/10893_3442661_1
> >
> > Let me know if it worked.
>
> As far as I understand, this is an example an Oracle database on NT,
> running on the same server as the SQL Server. We have a Solaris server
> for our Oracle DB, which makes ODBC connects more difficult.
>
> Thorsten
> --
> Sorry for broken quotations, I only have access to Google Groups at the
> moment.

you need the following :

1. a database which will access sql-Server (this is your solaris box)
2. a box where your odbc driver lives with an Oracle listener
3. 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).

regards

s.kapitza Received on Wed May 25 2005 - 02:47:29 CDT