ORA-28545 when trying to connect to SQL Server via Oracle DB Link after SQL Navigator Install
Hi,
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.
Thanks,
joe
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.
Thanks,
joe
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Everything was configured and working just fine before I installed the SQL Navigator software. I was able to select from the remote SQL Server DB using sqlplus. As soon as I installed SQL Navigator I started receiving this error whether using SQL Navigator or sqlplus. I just checked the following within the Registry and only found one ORACLE_HOME and it is correct...
HKEY_LOCAL_MACHINE>SOFTWAR