Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2005
    Posts
    16

    Question Unanswered: 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.

    BPG

  2. #2
    Join Date
    Dec 2002
    Posts
    1,245
    Ugh, 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

    Quote Originally Posted by BeijingPinkGirl
    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
    Have you hugged your backup today?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •