RE: A question for people who also know Sybase

[Bala, Prakash]

Title: RE: A question for people who also know Sybase

Melissa,

 

Finally made it work last evening. The interfaces file (like our tnsnames.ora) that is used by the Sybase client to connect to servers has 2 different formats that can be used: TLI and non-TLI. Was using TLI format for all servers. When I used a non-TLI format to these 2 servers, the connection went thru and the gateway started working. So I guess this is some kind of setup issue with the Sybase server.

 

If any of you have questions to configure Oracle Transparent Gateway with Sybase, I will be glad to help. The documentation is not really helpful.

 

Thanks

Prakash

 

-----Original Message-----
From: Godlewski, Melissa [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 20, 2002 3:29 PM
To: '[EMAIL PROTECTED]'
Subject: RE: A question for people who also know Sybase

Prakash,

Have you looked to see if there is some kind of ip deny or accept in place?

-----Original Message-----
From: Bala, Prakash [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 20, 2002 2:48 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: A question for people who also know Sybase

Jared, I tried the first 3 and didn't get any answer. Since we are an Oracle
shop and not a Sybase shop, we don't have any Sybase support. So I posted
here because somebody would have used Oracle Transparent Gateway with
Sybase.

-----Original Message-----
Sent: Wednesday, February 20, 2002 2:18 PM
To: Multiple recipients of list ORACLE-L

Ok, this really is an Oracle list, believe it or not.

Why not?:

a) do a google search
b) join a sybase list
c) hit the sybase tech support site
d) file a support request with sybase.

Jared

"Bala, Prakash" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
02/20/02 09:09 AM
Please respond to ORACLE-L

 
        To:     Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
        cc:
        Subject:        A question for people who also know Sybase

Hi,

Oracle 8.1.7.2 and Sybase 12.0 client on Solaris 2.8

We are trying to access 7 remote Sybase databases (all on NT) using a
Sybase
client (Adaptive Server Enterprise 12.0) installed on Solaris.

Have converted the IP addresses and the port numbers to Hexadecimal and
have
made the necessary changes to the 'interfaces' file on our Unix box.

We are able to successfully connect to 5 databases and retrieve data using
isql. But we get the following error for the remaining 2 sites when I
issue
the isql command:

CT-LIBRARY error:
ct_connect(): network packet layer: internal net library error: Net-Lib
protocol driver call to connect two endpoints failed

We are able to ping these 2 servers and also do the 'traceroute'
successfully.

Also, I am able to connect to these 2 locations using the Sybase client on
my workstation. This verifies that the IP address, port#, user-id and
password are correct.

Just the connection through Unix fails and have to make this work so that
our Oracle database can talk to Sybase using the Oracle Gateway. Oracle
Gateway is able to retrieve data from the remaining 5 Sybase servers.

TIA!

Prakash

--