paxmetrix.blogg.se

the configuration you have - 10.2 RDBMS on a Sun machine and HSODBC on Windows - is not supported. However, there are a couple of problems with your actual setup.

If you still use the initTelemetryDB1.ora file for the connection then the TelemetryDB1 DSN should be configured to access the SQL*Server 2008 database. So, in your setup when you want to access the SQL*Server 2008 database then the DSN should use an ODBC driver that can connect to a SQL*Server 2008 database. This DSN should then be configured to use an ODBC driver to connect to the non-Oracle database.

The way it works is that in the gateway init.ora file, in your case initTelemetryDB1.ora, the parameter HS_FDS_CONNECT_INFO points to a system DSN. We've been working for the last couple of weeks. But the same, when configured for MS SQL server 2000 works fine without any issues. I'm getting the above error for DB links between Oracle 10.2 and SQL Server 2008 R2. InitTelemetryDB1.ora file under ORACLE_HOME\hs\admin\ On Sun Sparc 5.9 where Oracle server is running. ORA-02063: preceding 2 lines from SCOPEX.WORLD Name not found and no default driver specified (SQL State: IM002 SQL Code: 0)

ORA-28500: connection from ORACLE to a non-Oracle system returned this message: I'm getting below error when using the DB link between Oracle (10.2.0.2 which is on Sun Sparc) and MS Sql server 2008 R2.