Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Sybase to Oracle - Connecting to Remote server From Sybase

Posted on 2003-03-30
3
Medium Priority
?
1,759 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
1 Comment
 
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

[Webinar] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

Question has a verified solution.

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

Often, the users face difficulty in accessing Outlook 2016 PST files on Windows 10 computer. One of the reasons behind it is the improper functioning of MS Outlook when the user tries to open it. MS Outlook suddenly stops working, or it will not op…
A quick solution showing how to control and open a POS Cash Register Drawer using VBA with MS Access.
In a question here at Experts Exchange (https://www.experts-exchange.com/questions/29062564/Adobe-acrobat-reader-DC.html), a member asked how to create a signature in Adobe Acrobat Reader DC (the free Reader product, not the paid, full Acrobat produ…
Whether it be Exchange Server Crash Issues, Dirty Shutdown Errors or Failed to mount error, Stellar Phoenix Mailbox Exchange Recovery has always got your back. With the help of its easy to understand user interface and 3 simple steps recovery proced…
Suggested Courses

564 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