Results 1 to 4 of 4
  1. #1
    Join Date
    Oct 2003
    Location
    Sweden, Stockholm
    Posts
    14

    Question Unanswered: MSSQL 2005 Linked servers, Oraoledb, 64 bit Windows 2003 Server

    I have installed SQL 2005 (X64) on 64-bit Windows 2003 server (AMD). One of my databases need to connect several Oracle databases on 32 bit servers.

    I managed to install Oracle 32 bit Client (was unsuccessful with 64 bit installation) and could set up the odbc (32). But I coul'nt find Oracle under linked servers!

    Does anyone know what I need to do?
    /*
    Fari Sah
    */

  2. #2
    Join Date
    Oct 2006
    Posts
    3
    Hi,

    This was a major problem for me too, i installed the 64bit Oracle driver
    "Oracle Database 10g Release 2 (10.2.0.1.0) for Microsoft Windows (x64)" from Oracle download page. This driver i could use from Linked Server in SMO.

    // Ron.

    P.S
    Dont forget to check "Allow inprocess" in the provider options, i needed to do this.

    D.S

    Hmm.. i still have som problem when i update data via linked server,

    Msg 7333, Level 16, State 2, Line 2
    Cannot fetch a row using a bookmark from OLE DB provider "OraOLEDB.Oracle" for linked server "xxxxxx".
    Last edited by rjohansson; 11-14-06 at 03:39.

  3. #3
    Join Date
    Oct 2003
    Location
    Sweden, Stockholm
    Posts
    14
    Thanks!
    I have asked our Oracle specialist to download the mentioned release.
    Strange error! Can you script a query from your linked server?
    /*
    Fari Sah
    */

  4. #4
    Join Date
    Oct 2003
    Location
    Sweden, Stockholm
    Posts
    14
    Thank!
    I could set up linked servers.
    /*
    Fari Sah
    */

Posting Permissions

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