How to link/connect to Oracle server from SQL server 2000?

Greetings,
I want to connet to Oracle databse from SQL server 2000 since I am more comfortable with SQL 2000 client package. The oracle server is 8i or above.
I am running a SQL Server 2000 on a PC with Windows XP OS.
Please help what I need to do and configuration information.

Thank you all in advance.

BPGUgh, I'm not really sure that you want to do this. Try downloading the freeware version of Quest's TOAD for Oracle. That being said, if you really insist:

1. Install the Oracle client on your Windows XP box. Choose the client install.

2. Configure your SQL Net settings for the Oracle connection.

3. Using either Enterprise Manager or Query Analyzer (spaddlinkedserver). Add the Oracle instance to your SQL Server. The server instance on your PC must be up and running. Specific settings for an Oracle server can be found in BOL or Google.

4. Query the linked server by using OPENQUERY or OPENROWSET.

I AM NOT recommending this. The client interface for Oracle as a SQL worksheet which you can use and which is adequate for most things. The freeware version of TOAD (already mentioned) is equally capable (and in some respects superior to QA).

Regards,

hmscott

Greetings,
I want to connet to Oracle databse from SQL server 2000 since I am more comfortable with SQL 2000 client package. The oracle server is 8i or above.
I am running a SQL Server 2000 on a PC with Windows XP OS.
Please help what I need to do and configuration information.

Thank you all in advance.

BPG