I have 9.2 installed on Win2k. I am trying to use it's heterogeneous services. I did exactly what Note:233374.1 and Note:115992.1 asks to do.
First of all, if I connect to MS SQL Server using login with blank password (like "sa"/""), it does not work. Ok, I've changed sa's password to be some password. Now it says me:
>select * from sysobjects@hsodbcsql
>ERROR at line 1:
>ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
>[Generic Connectivity Using ODBC][Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified (SQL State: IM002; SQL >Code: 0)
>ORA-02063: preceding 2 lines from HSODBCSQL