Link SQL2000 and Oracle

hi, does anyone know how to link SQL2000 to Oracle? because i need to use a sql statement which involve both the SQL2000 table and an Oracle table.

Thanks in advance.You have two choices here:

either you create two connections and retrieve from each database what is needed into datasets and use that data then (works without a problem), or you set up a linked database in SQL server that points to the Oracle database ...
If you do not know how to do that second one, go for the first solution ...|||thanks for the solutions..