none
Installing Microsoft.ACE.OLEDB.12.0 provider in x86 SQL Server issue. RRS feed

  • Question

  • I am trying to query into Excel 2007 file data from SQL Server x86 version.


    I have a unique environment where the Windows Server machine is x64 version. This windows server contains the following installed in it:

    1.       Default instance SQL Server x64 Enterprise edition

    2.       Named instance SQL Server x86 Enterprise edition

    3.       2007 Office System Driver (installed from http://www.microsoft.com/downloads/details.aspx?FamilyID=7554F536-8C28-4598-9B72-EF94E038C891&displaylang=en)


    Note, that the same windows server machine contains both SQL Server x64 and x86 (named instance) installed.

    The reason I need both SQL Server x86 and X64 versions on the same machine, is that I am using x86 (32 bit version) of SQL Server just for Excel file querying purposes(since there are no 64 bit drivers for Excel querying). This x86 SQL Server instance would form a bridge between SQL ServerX64 and Excel file.


    Now, when I go to the 32 bit SQL Server Name Instance I do not find “Microsoft.ACE.OLEDB.12.0” providers in there.  I have restarted the machine/sql server, just to make sure the installation is complete.


    Do you know what the issue is here?? Can I install 2007 Office System Driver on a Windows x64 server machine with a SQL Server x86 named instance? If yes, why dont I see the “Microsoft.ACE.OLEDB.12.0” providers in the x86 instance of SQL Server


    Thanks a ton in helping out!!!

    Wednesday, February 11, 2009 5:42 PM

Answers

  • I got this figured out. It was just that SQL Server installer was automatically detecting the machine was 64 bit and installing SQL Server64 bit as well although I choose a 32 bit SQL Server installation. Once I realized that, I could override that through the "Options" section in the home installation page to install only 32 bit SQL Server instead.

    Thanks!
    Friday, February 20, 2009 1:27 AM

All replies

  • I verified it on SQL2K X86 on a W2K3 X64 machine. 
    1. Install provider is not related with SQL Server instance. When you register it, it's there. When SQL Server enumerated providers, it will see the provider we registered.
    2. After you install the provider, in Management, try to create a new linked server, drop down "Provider name", you will see "Microsoft Office 12.0 Access Database Engine OLE DB Provider".

    If you still can't solve the problem, please give me info such as OS version (2k3 or 2k8 X64?) and SQL Server version (2000, 2005 or 2008)?

    Thanks

    Friday, February 13, 2009 1:31 AM
    Moderator
  • I got this figured out. It was just that SQL Server installer was automatically detecting the machine was 64 bit and installing SQL Server64 bit as well although I choose a 32 bit SQL Server installation. Once I realized that, I could override that through the "Options" section in the home installation page to install only 32 bit SQL Server instead.

    Thanks!
    Friday, February 20, 2009 1:27 AM
  • Hi Ying, I have a similar issue with Ms ACE. I have data streaming into an Excel 2007 via a DDE link, and I need to find the most efficient way of getting that data into SQL server 2008/64bit. My first approach was to try and form a linked server, but having installed ACE I couldn't see it in 'providers', is there a registration step in 'management' that I'm overlooking? I tried to search online help but couldn't find any references. I also tried to access the data via a simple import package, but this only worked when the workbook was closed, is this correct? Given that I'd like to record the data on a 1 minute schedule that's going to be a problem. Any thoughts? Thanks for your help....Marcus
    Thursday, November 12, 2009 10:11 AM
  • Could you explain how to register a provider for a linked server?

    Let's say I want to register the MS Excel 14.0 ODBC Driver as a provider.


    mysorian
    Tuesday, August 3, 2010 8:58 PM