We setup a system DSN to a SQL Server DB and then setup Oracle Heterogeneous services on our 10.2.0.4 Oracle DB so we can select from SQL Server via a public DB link in Oracle. This was working just great, I was able to use Oracle SQL Plus to select from SQL server using the database link. Had no issues with the link or communication so if I ran the following I was returned the proper information:
select * from "User"@sqlserver;
Then I installed SQL Navigator. Something with the install of that software hosed the connection. Whether I try that same select statement from SQL Navigator or SQL Plus I get the following error:
ERROR at line 1:
ORA-28545: error diagnosed by Net8 when connecting to an agent
Unable to retrieve text of NETWORK/NCR message 65535
ORA-02063: preceding 2 lines from SQLSERVER
I tried un-installing SQL Navigator and that didn't fix it.
I have absolutely no idea where to go with this, I really don't want to start all over again from scratch I'm hoping someone out there may be able to point me in the proper direction to fix the problem at hand.