Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Database link from Oracle 10.2.0.5 (Linux-x86) to MS SQL Server 2012 (x64)

rootsmanJan 25 2016 — edited Jan 26 2016

Please guys, i really need your help regarding this question.

I tried by using freetds driver but when i use db link i get this error:

ORA-28500: connection from ORACLE to a non-Oracle system returned this message:

[Generic Connectivity Using ODBC][S1000] [9013]General error in nvITrans_BeginT - rc = -1. Please refer to the log file for details.

ORA-02063: preceding 2 lines from MIXERI

Just to mention i can connect to remote sql server via isql tool with no problem at all. I investigate a lot and i didn't find any kind of solution for this error, so therefor i will try to find any other alternative way.


Is there any other way to manage communication via db link between this 2 DB systems?

Thank you

This post has been answered by Mkirtley-Oracle on Jan 26 2016
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 23 2016
Added on Jan 25 2016
9 comments
2,165 views