none
OLE DB drivers for IA64 RRS feed

  • Question

  • Hello,

    does Oracle OLE DB or Ado.Net drivers exists for Itanium 64bit architecture with Windows 2008 server installed?
    Friday, October 10, 2008 5:36 AM

All replies

  • Win2008 comes with 64bits OLE DB driver I think it also includes Itanium because the Win2003 download version also comes in Itanium.  So if you cannot find it check your Windows components.

     

    http://blogs.msdn.com/data/archive/2007/06/05/64-bit-oledb-provider-for-odbc-msdasql-available-in-longhorn-server-starting-beta-3.aspx

     

     

    • Unmarked as answer by -VB- Friday, January 16, 2009 8:47 AM
    Sunday, October 12, 2008 8:19 PM
  • The same problem is with excel 2007 (*.xlsx) files. In local i can create and load data into xlsx files.
    But when i create job it fails.

    I don't find drivers for Itanium 64-bit Windows 2008 server. Can anybody help?
    Friday, January 16, 2009 8:51 AM
  • There is no 64-bit version of OLEDB provider for Excel. Jet and ACE OLEDB providers are 32-bit. You could try to use managed reader for Excel from my site. It is .NET component that was compiled to run on any CPU and you should be able to run it on I64
    Val Mazur (MVP) http://www.xporttools.net
    Friday, January 16, 2009 11:12 AM
    Moderator
  •  There must be 64bit OLE DB driver in Windows 2008 Itanium because I just checked and there is downloadable version for Windows 2003 64 bits Itanium.  And your problem about job failing with Excel 2007 to Oracle is a separate thread, because since Excel is only 32bits you actually need to use the x86 version of the OLE DB driver and make sure you install the x86 version of SQL Server Agent. If you are running it as a SSIS package you may need to develop it as x86 make sure the permissions used to develop the package is Admin and also run SQL Server Agent as Admin.  The Agent can run with a proxy account but the account used to create the package must be admin.  So OLE DB driver is just one of your issues.






    MCPD Web C#, MCTS TFS, MCITP BI and DBA
    Saturday, January 31, 2009 8:15 PM
  • -VB- said:

    Hello,

    does Oracle OLE DB or Ado.Net drivers exists for Itanium 64bit architecture with Windows 2008 server installed?


    Oracle has a 64-bit OLEDB provider that you can download:

    http://www.oracle.com/technology/tech/windows/ole_db/index.html

    Microsoft no longer supports OLEDB for Oracle.

    Personally, I would recommend using the .NET libraries, either Microsoft's or Oracle's ODP.NET, instead of OLEDB.

    With respect to the 64-bit OLEDB provider from Microsoft (MSDASQL), this is simply a bridge from 64-bit OLEDB to 64-bit ODBC. It enables you to use a 64-bit ODBC driver from the ADO.NET OLEDB libraries. It does not allow you to use 32-bit OLEDB providers (such as Jet or ACE) or 32-bit ODBC drivers from a 64-bit .NET application.
    Paul ~~~~ Microsoft MVP (Visual Basic)
    Tuesday, February 3, 2009 6:08 PM
  • Moving Excel with a Job is an ETL task using SSIS and yes Microsoft provides a connector to Oracle and before that I have helped developers use existing connection to Oracle because ETL is a OLE DB operation by default.  And I have added the x64 or IA64 version cannot be used in Excel operation because Office is still x86 which a 32bits application.  So there is a Microsoft Oracle connector using OLE DB for ETL operations and before that what comes with SQL Server 2005/8 can be made to work with Oracle and all RDBMS.  I can provide threads as needed,  I am RDBMS vendor agnostic.


    http://www.microsoft.com/downloads/details.aspx?FamilyId=D9CB21FE-32E9-4D34-A381-6F9231D84F1E&displaylang=en





    MCPD Web C#, MCTS TFS, MCITP BI and DBA
    Tuesday, February 3, 2009 6:44 PM