Problems with Linked Server to ORACLE (on SQL 2005 64bit)

Hi all

I have a big problem with creating a linked server to ORACLE database!

- I have installed ORACLE Client 10g on my server (Windows Server 2003 64 bit)
- With ORACLE Tools I am able to connect to the ORACLE Server
- When I try to connect in SQL Server I get the following error:
Cannot create an instance of OLE DB provider "OraOLEDB.Oracle" for linked server
"MISPROD.WORLD".

I have tried I guess all combinations of getting data out of ORACLE ... :-(
For example:
- SELECT * FROM OPENQUERY([MISPROD.WORLD], 'SELECT * from ORACLE_TABLE')
- SELECT * FROM [MISPROD.WORLD]...ORACLE_TABLE
I allways get the same error and I dont know what to do ...

Would by very very happy for any comment.

Best regards
Frank Uray

I got the solution:

- Use 64bit ORACLE Client (10.2.0.1)
- Enable "Allow Inprocess"

Frank Uray