I have recently installed MDAC 2.8 (Microsoft Data Access Components) on a machine running SQL Server 2000. I have created an odbc source to connect to a remote Oracle database (B).

I have created a publication in SQL Server and I want B to be its subscriber.
But I get an error telling that enterprise manager cannot check if the odbc source is a valid source or not.

the error message is the following:
Error 22001:NA000[Microsoft][ODBC driver for Oracle][Oracle]

I know that it is a valid source because a program written by myself uses it.
The driver provided by Oracle works as well so I think it isn't a configuration problem.

Any help would be appreciated!