Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.oracle -> Re: Connection Oracle - Sybase

Re: Connection Oracle - Sybase

From: Ollie <oamd_at_yahoo.com>
Date: 12 Apr 2004 11:59:02 -0700
Message-ID: <82f47a3c.0404121059.11248a79@posting.google.com>


Jim Smith <jim_at_jimsmith.demon.co.uk> wrote in message news:<LScKu91wSleAFwa9_at_jimsmith.demon.co.uk>...
> In message <b7758dc3.0404111437.7d20c2c4_at_posting.google.com>, Gianfranco
> Poli <atikin_at_email.it> writes
> >I need to insert row in a sybase's table from Oracle.
> >Sybase is on a Unix machie and Oracle is on a Win2000Server o the same
> >network.
> >I tried with Transparent gateway but nothig, I have problem to
> >configurate o ORACLE.
>
> What have you tried? What error do you get?
>
> IIRC, you need to do the following.
>
> Install transparent gateway on the Sybase machine so that you have an
> oracle service running on that machine.
>
> Configure TNSNAMES.ORA on the Oracle machine to point at the oracle
> service.
>

You should looki into setting up CIS.

> Create the database link to point at the service defined in tnsnames.ora
>
> You also need to note that Sybase is case sensitive and Oracle folds
> everything to upper case. If you Sybase table name is _myTable_, then
> you need to use "myTable" in you insert statement.
>
> Transparent Gateway is rather old. Its now called Heterogeneous Services
> and may well have changed a lot.
Received on Mon Apr 12 2004 - 13:59:02 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US