?
Solved

Sybase to Oracle - Connecting to Remote server From Sybase

Posted on 2003-03-30
3
Medium Priority
?
1,751 Views
Last Modified: 2012-05-04
I am trying to connect to Oracle thru' Sybase Remote server operation. I get the following error.

com.sybase.jdbc2.jdbc.SybSQLException: Internal Ct-Lib/Cs-Lib error 84083974: 'ct_connect(): network packet layer: internal net library error: Net-Library operation terminated due to disconnect'.

     at com.sybase.jdbc2.tds.Tds.processEed(Compiled Code)
     at com.sybase.jdbc2.tds.Tds.nextResult(Compiled Code)
     at com.sybase.jdbc2.jdbc.ResultGetter.nextResult(ResultGetter.java:69)
     at com.sybase.jdbc2.jdbc.SybStatement.nextResult(Compiled Code)
     at com.sybase.jdbc2.jdbc.SybStatement.nextResult(SybStatement.java:182)
     at com.sybase.jdbc2.jdbc.SybStatement.executeLoop(SybStatement.java:1596)
     at com.sybase.jdbc2.jdbc.SybStatement.execute(SybStatement.java:1588)
     at com.sybase.jdbc2.jdbc.SybStatement.execute(SybStatement.java:766)
     at com.sybase.jisql.ExecQueryThread.executeIt(Compiled Code)
     at com.sybase.jisql.ExecQueryThread.run(Compiled Code)

I tried with SQL server. Above error keeps coming.

When I try to connect to other sybase database in a similar fashion, it is working properly. Whether any other product needs to be install to connect to non-sybase databases e.g., Direct connect.

srinath
0
Comment
Question by:vcsrinath
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 4

Accepted Solution

by:
gletiecq earned 2000 total points
ID: 8239444
You're trying to connect to Oracle using TDS, and it's not supported by Oracle.  Check your definition of the remote server -- I think you have a bad parm about what kind of server it is.  It looks like the local server thinks the remote server is a Sybase database.

Greg
0

Featured Post

Get MySQL database support online, now!

At Percona’s web store you can order your MySQL database support needs in minutes. No hassles, no fuss, just pick and click. Pay online with a credit card.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This is a fine trick which I've found useful many times, when you just don't want to accidentally run a batch script or the commands needs administrator rights.
Active Directory can easily get cluttered with unused service, user and computer accounts. In this article, I will show you the way I like to implement ADCleanup..
Michael from AdRem Software outlines event notifications and Automatic Corrective Actions in network monitoring. Automatic Corrective Actions are scripts, which can automatically run upon discovery of a certain undesirable condition in your network.…
Michael from AdRem Software explains how to view the most utilized and worst performing nodes in your network, by accessing the Top Charts view in NetCrunch network monitor (https://www.adremsoft.com/). Top Charts is a view in which you can set seve…

741 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question