SQL Server Performance

Linked Servers and OLEDb Prvoider for Oracle on 64

Discussion in 'SQL Server 2005 General Developer Questions' started by mikewhite, Aug 3, 2006.

  1. mikewhite New Member

    Please help. We are running SQL Server 2005 64bit on an Windows 2003 Server Machine using AMD Opteron Processors. We are trying to setup linked servers to some Oracle 9i Databases on 32bit servers. We need to install ODBC/OLEDB providers for Oracle to achieve this. we are having difficulty finding out a few things :

    i. How to install Microsoft OLEDB for Oracle - we have MDAC 2.8 installed, but still there is no provider. The question is what is the correct OLEDB provider and how do we get it and is there such a thing as 64bit MDAC ?

    ii. All literature suggests that 64bit version of these products are only available on Itanium 2 or higher processors. Is there any way to utilise these technologies on 64 bit Opteron.

    Your help would be much appreciated as we are at our wits end for what is turning out to be quite an expensive project (we are hiring the 64bit server).

    Many thanks

    Mike
  2. FrankKalis Moderator

  3. mikewhite New Member

    Hi Many thanks for this.

    The problem i seem to be getting is that I cant find the Microsoft OLEDB provider for Oracle. In the linked server gui it is not in the drop down even tho the Oracle client has been installed. MDAC 2.8 has been installed also.

    Do you have any ideas ?

    Thanks

    Mike
  4. mikewhite New Member

    Hi Many thanks for this.

    The problem i seem to be getting is that I cant find the Microsoft OLEDB provider for Oracle. In the linked server gui it is not in the drop down even tho the Oracle client has been installed. MDAC 2.8 has been installed also.

    Do you have any ideas ?

    Thanks

    Mike
  5. mpex04 New Member

    Microsoft does not have a 64 version of the OLEDB provider for Oracle. You will have to use the 64-bit Oracle Provider for OLE DB. According to Microsoft, they currently do not have plans for such a version. I would also warn you that the Oracle drivers have a bug that causes issues with numeric values. This is a documented issue that Oracle is aware and will be fixed in a future release. Basically, we had to convert any numeric field using TO_CHAR inside of views on the Oracle side.
  6. mikewhite New Member

    Hi

    Many thanks for this. I guess we will need to rethink - your help is very much apreciated.

    Regards

    Mike

Share This Page