Results 1 to 4 of 4
  1. #1
    Join Date
    Mar 2002
    Location
    East Coast
    Posts
    5

    Exclamation Unanswered: Installing the ODBC

    Okay, First off as if you did not know i have a small amount of knowledge, so you may think this stupid but i need a hand. I am trying to use SQL 7 to hook up to an Oracle server. This is my problem for some reason i am not able to connect through a linked server. Is it possible that i did not install the ODBC correctly. Books online makes reference to doing this and makes in sound like i am supposed to use a program to do this. All i did was drop the dll where it was needed, should i have run a program to do this.

  2. #2
    Join Date
    Dec 2001
    Location
    Toronto, Canada
    Posts
    335
    You need to install the Oracle Drivers for ODBC. You should be able to go into ODBC Admin utility and see Oracle under the list of drivers. You should be able to create a DSN connection to Oracle using the ODBC driver. To test the connection you could use ODBCPING. See the Microsoft article.

    INF: ODBCPING.EXE to Verify ODBC Connectivity to SQL Server (Q138541)
    MCDBA

  3. #3
    Join Date
    Apr 2002
    Location
    Colorado
    Posts
    1

    Same thing but I need OBDC for RedBrick.

    Do you know where I can get this? I tried installing one, but it doesn't show up in OBDC as a driver choice. I've serched on the net and can't find it any where? I'm in the process of creating a datamart.
    Thanks for any help.

  4. #4
    Join Date
    Mar 2002
    Location
    Edinburgh
    Posts
    8
    You need to get a download of the latest MDAC

    (Microsoft Data Acsess Components) which will give you all the drivers that you require to create a connection to an oracle server.

    http://www.microsoft.com/data/download_270RTM.htm


Posting Permissions

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