By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,504 Members | 1,884 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,504 IT Pros & Developers. It's quick & easy.

Connection Oracle - Sybase

P: n/a
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.

I installed o win2000 the ODBC client for Sybase and all work but
don't in ORACLE (I tried to use transparent gateway with dblink).

There is some one that had tried ok with these situation?

at****@REMOVEemail.it
Giafranco Poli
Jul 19 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
In message <b7**************************@posting.google.com >, Gianfranco
Poli <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.

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.
--
Jim Smith
Because of their persistent net abuse, I ignore mail from
these domains (among others) .yahoo.com .hotmail.com .kr .cn .tw
For an explanation see <http://www.jimsmith.demon.co.uk/spam>
Jul 19 '05 #2

P: n/a
Jim Smith <ji*@jimsmith.demon.co.uk> wrote in message news:<LS**************@jimsmith.demon.co.uk>...
In message <b7**************************@posting.google.com >, Gianfranco
Poli <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.

Jul 19 '05 #3

P: n/a
In message <b7**************************@posting.google.com >, Gianfranco
Poli <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.


You have cross-posted this to comp.databases.oracle. This is a dead
group. You should use one of c.d.o.server, c.d.o.tools or c.d.o.misc
--
Jim Smith
Because of their persistent net abuse, I ignore mail from
these domains (among others) .yahoo.com .hotmail.com .kr .cn .tw
For an explanation see <http://www.jimsmith.demon.co.uk/spam>
Jul 19 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.