Connection to Oracle10g

(Hope this is the right forum to post this message. If not, could someone please tell me the right one?)

I'm trying to connect to oracle 10g from sql server 2000.
Oracle client tools 10g is installed on the same server as sql server.
MDAC 2.8 installed.
Tnsnames.ora file is correct. (checked with the oracle dba..).
But I still can't connect. Error message is:

Error source: Microsoft Ole Db provider for ODBC drivers
Error Description: [Microsoft][ODBC driver for Oracle][Microsoft]

Tried both odbc and oledb provider connections within dts package...

(And: cannot connect to old oracle (still running) version 9i...)

Connecting via sql*plus to old oracle working fine... but not to new
oracle server.
Tnsping to both servers working fine...

Anybody who has an idea?

Regards Jan

The Microsoft ODBC driver only provides full support for Oracle 7, and some limited support for Oracle 8 through emulation. It is unsupported for Orcale 9. You can see the roadmap for our data components via: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/Dnmdac/html/data_mdacroadmap.asp. Please contact Oracle for their ODBC driver. Thanks|||

Thanks, should do it, i hope ;-)

Jan