Error using Linked Server

[tgriffin]

I am trying to connect to an Oracle DB by using a linked server in SQL 7. Often I will get errors like ORA:03113 end-of-comunication file or even SQLConnectAttr failed. These are seperate instances of errors but they seem to be happening more often.

Im not really sure why or what is causing this to happen. Any help would be greatly appreciated.

Thanks,
tgriffin

 

[Guest_imported]

The oracle server is using encryption. Try to copy across the seed file to the sql server and this will resolve your problem.

Good luck