Re: connecting to SQL Server

I think so too that the whole transparent gateway functionality has to be licensed additionally. But there
is a part of it ( hsobdc agent), that comes with the database. Not all features are supported( ODBC spec), e.g. no distributed transactions, but the usual ins/upd/del/exec procedure works.

Setup on the Oracle server( NT/XP OS assumed...) is simple:

- set up System Settings ODBC Datasource; let it point to the SQL-Server
- configure hsodbc.ini; pointing to the datasource
- create a listener entry for the hsodbc agent.
- create a tnsnames entry for hsodbc
- create a database link using that tnsnames entry

Now you'd see something under user_tables_at_SQLServer

Mark

"Niall Litchfield" <niall.litchfield_at_dial.pipex.com> schrieb im Newsbeitrag news:3f1da0db$0$15032$cc9e4d1f_at_news.dial.pipex.com...
> "Peter" <depend3_at_yahoo.com> wrote in message
> news:%JfTa.26861$F92.3153_at_afrodite.telenet-ops.be...
> > We would like to make an interface between SQL Server and Oracle 8i(9i)
> > where the data comes mainly from SQL Server. What is the best way to do
> > this? Any tools available?
>
> There is an Oracle product called transparent gateway. I *believe* this is
> extra cost. There is a neat MS product called DTS which isn't. There is
the
> programming language of your choice which also isn't chargeable, but may
> cost.
>
> I'd go DTS.
>
>
> --
> Niall Litchfield
> Oracle DBA
> Audit Commission UK
> *****************************************
> Please include version and platform
> and SQL where applicable
> It makes life easier and increases the
> likelihood of a good answer
> ******************************************
>
>
Received on Wed Jul 23 2003 - 09:03:42 CDT