Microsoft Office Drivers (64bit and 32bit) on the same Server

Posted on 2014-08-18
Last Modified: 2016-02-11

Is it possible/OK to install the Microsoft Office 32bit and 64bit drivers on the same server. We have a database server running MSSQL with Business Intelligence. I need SSRS to connect to a 64bit access database but I also need SSIS to connect to a 32 bit MS Excel file.

What is the best way to do this..?

Thanks, Greg
Question by:spen_lang
    LVL 34

    Expert Comment

    Install the 64 bit on the server and the 32 bit on the Virtual Server or the Hyper/V

    Author Comment

    Sorry I do not understand what you mean, I need both set of drivers on the same server... SSIS and SSRS are running on the same server.

    Accepted Solution

    I have installed both set of drivers and seems to work OK

    Author Closing Comment

    Solved problem in the end

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Here's a requirements document template for an integration project (also known as Extract-Transform-Load or ETL) based on my development experience as an SQL Server Information Services (SSIS) developer over the years.
    Outlook Free & Paid Tools
    The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…
    Learn how to make your own table of contents in Microsoft Word using paragraph styles and the automatic table of contents tool. We'll be using the paragraph styles in Word’s Home toolbar to help you create a table of contents. Type out your initial …

    737 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now