I have gone through the usual process to setup the HS link:
0. Setup DSN on oracle server machine (10g, winXP)
1. Modify the listener.ora, initMEDWORXX.ora, and tnsnames.ora files
2. Start Listener (successful)
3. confirm with tnsping (successful)
4. Create DBLINK --- creates successful ... but when I try to use it I get this error:
ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
[Generic Connectivity Using ODBC][Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. (SQL State: 28000; SQL Code: 18456)
ORA-02063: preceding 2 lines from MEDWORXX.WORLD
.
Looks like a user/psswd issue.
1. How do I specify the domain and username correctly in the DBLINK? If I leave out the double quotes, I get an error. Also the password is case sensitive.
CREATE DATABASE LINK "MEDWORXX.WORLD" CONNECT TO "DOMAIN\USERNAME" IDENTIFIED BY psswd USING 'MEDWORXX';
2. I read somewhere about changing the oracle service to run as myself instead of the machine ... does that have anything to do with it?
Thanks
Jason