Post reply

SQL Server 2005 64-bit - fetch data from Oracle

  • May 8, 2007 at 9:47 am

    #704980

    Were you able to find any answer on this topic?

  • May 8, 2007 at 11:30 am

    #705022

    Here is the best single discussion of 64-bit, SSIS and Oracle connectivity that I have found....

    http://stevemchugh.blogspot.com/2007/02/adventures-of-ssis-and-oracle-in-64bit.html

     

  • May 11, 2007 at 3:25 pm

    #705994

    I had a similar problem with connecting an SSIS package on a 64 bit server to Pervasive.SQL using 32 bit drivers. 

    Solution:

    1) Build the package in 32 bit mode.  

    2) Register the pervasive oledb drivers using the 32 bit regsvr32. 

    3) Use 32 bit ODBC admin utility to create odbc connections.

    Path to 32 bit version of odbc admin and regsvr

    C:\WINDOWS\SysWOW64\odbcad32.exe

    C:\WINDOWS\SysWOW64\regsvr32.exe

  • May 14, 2007 at 5:50 am

    #706179

    Thanks for your concern!

    No, there is no 64-bit Microsoft driver for Oracle and there will be none according to Microsoft.

    I have installed both 32- and 64-bit Oracle drivers for OLE DB on our development/test server(read why in interesting link above, or search MS for 64-bit SSIS or SSAS) but only 64-bit in Production.

    Regards

Viewing 4 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply