ODBC Error when connecting from Oracle to SQL Server 2005
I have an application and when data in a table is updated a trigger is executed and sends information from oracle to sql server 2005. This was working correctly and all of a sudden I began seeing the following error message:
Detail Message=java.sql.SQLException: ORA-28500: connection from ORACLE to a non-Oracle system returned this message: [Generic Connectivity Using ODBC][S1000] General error in nvITrans_BeginT - rc = -1. Please refer to the log file for details. ORA-02063: preceding 2 lines from KANCARD
I'm not sure why this error occurred or how to correct it. Help is greatly appreciated as this is in our production environment.