Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2003
    Posts
    232

    Lightbulb Unanswered: connecting mssql to access and oracle

    How do i connect from mssql to access database and oracle


    A good example would be fine

    I would like to use ODBC or any free tools


    THANKS
    SEJ
    bigfoots

  2. #2
    Join Date
    Oct 2001
    Location
    England
    Posts
    426
    Create a linked server or use openquery/openrowset.

    Access shold be easy as you should already have the driver but will need to install the oracle connectivity layer for oracle.

  3. #3
    Join Date
    Oct 2003
    Posts
    232
    Originally posted by nigelrivett
    Create a linked server or use openquery/openrowset.

    Access shold be easy as you should already have the driver but will need to install the oracle connectivity layer for oracle.



    Can you give some details
    I have sql developer 2000 and oracle9i and access on the same machaine with 2000 professional
    Novice i am in connectivity issues
    with example will help


    SJ
    bigfoots

Posting Permissions

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