SQL> select * from smt008@sprint.world;select * from smt008@sprint.world *ERROR at line 1:ORA-28545: error diagnosed by Net8 when connecting to an agentUnable to retrieve text of NETWORK/NCR message 65535ORA-02063: preceding 2 lines from SPRINT.WOR

If the link was working before , quickly check and verify the following :

1.Confirm whether the dblink password on the remote database wasnt changed.
2.Check whether the table you are trying to query exists on the remote database.
you can "desc remote_table@dblink"
3.If the password was changed , recreate the link using the new password.

Recreate the Oracle database link with the proper username and password. Note that the username and password must be in double quotes.

Example:

create public database link ODBC connect to "sa" identified by "pencil" using 'hsodbc'.


Rgds

FSN