Oracle OLE DB provider (64-bits)

Hot Topic

semicolon terminator
convert millisecond to "hh:mm:ss" format
How to sort table in sql2000 with ipaddress(format x.x.x.x) as column with nvarchar datatype in ascending order
Performance of Fuzzy Lookup?
view server permissions error,view schema permissions erros
Reporting Servers - Export to Multiple tabs in Excel
SQL Server 2005
Scheduling through sql agent
Problems with Date And Time
Invalid use of side-effecting or time-dependent operator in 'INSERT' within a function.

SQL Server

Is there any way to 'undo' an update query?
Unable to replicate over websync but via the lan
Custom Source Component Problem?
SSIS Package OLE DB Connection Issue
package variable question
I can't show a calculated member
creat a solution in SQLServer 2005 and intall that solution in SQLServer 2005 Express
New To Databasing
SQL Server 2005 Database Diagrams
Change a dimension table name?

Oracle OLE DB provider (64-bits)

Hi all,
We tried running the replication in 32 bits platform  and it works fine.  Currently, We are trying to implement replication from oracle to mssql 2005 which is running in 64 bits platform.  When we add an oracle publisher, it shows error '21629'.  Seems like the downloaded Oracle ole db provider is 32 bits.  Is there any way to check the ole db version Also, I found that Oracle OLE DB provider (64-bits) is unsupported in Oracle that I can't find the source in OTN.   Where can I download the 64 bits version   Thanks in advance! 


Answer this question

Oracle OLE DB provider (64-bits)

  • SpGlover

    we are running 64-bits mssql2005.  And suggested by oracle support, we  needed to install oracle 10G client 64 bits(9i client 64bit is not available).  And now, it can connect to oracle DB. Thanks a lot.

  • NB76

    Hello,

    What version of Oracle server and client are you using
    Are you installing 32bit or 64bit of SQL server on your 64 bits platform

    Here is a direct quote from BOL, please see if it help to solve your problem.

    ===================================
    SQL Server Error 21624 or Error 21629 is Raised

    For 64-bit Distributors, Oracle publishing uses the Oracle OLEDB Provider for Oracle (OraOLEDB.Oracle). Make sure that the Oracle OLEDB provider is installed and registered on the Distributor. If the provider is not installed and registered, one or both of the following error messages is shown:

    • "Unable to locate the registered Oracle OLEDB provider, OraOLEDB.Oracle, at distributor '%s'. Make certain that a current version of the Oracle OLEDB provider is installed and registered at the distributor."

    • "The CLSID registry key indicating that the Oracle OLEDB Provider for Oracle, OraOLEDB.Oracle, has been registered is not present at the distributor. Make certain that the Oracle OLEDB provider is installed and registered at the distributor."

    If you are using Oracle client software version 10g, the provider is OraOLEDB10.dll; for version 9i, it is OraOLEDB.dll. The provider is installed in %ORACLE_HOME%\BIN (for example, C:\oracle\product\10.1.0\Client_1\bin). If you determine that the Oracle OLEDB provider is not installed on the Distributor, install it from the Oracle client software install disc provided by Oracle. For more information, see Configuring an Oracle Publisher.

    If the Oracle OLEDB provider is installed, make sure that it is registered. To register the provider DLL, execute the following command from the directory in which the DLL is installed, and then restart the computer:

    1. regsvr32 OraOLEDB10.dll or regsvr32 OraOLEDB.dll.

    ===================================

    Regards,

    Gary Chen
  • Oracle OLE DB provider (64-bits)
Answer this question