Unable to Connect 2007 Access DB using SSIS OLEDB Connection on Denali RRS feed

  • Question

  • When I tried to Connect tpo MSAccess 2007 got the following Error..

    Error : “Unrecognized Database Format”, even I selected the Proper Provider

    Re Produce Steps

    1. Download and Install the 2007 Office System Driver : Data Connectivity Components from http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=23734

    2. Open SSIS Project à New the Dataflow Task

    Add the OLEDB Source and Choose the Provider as “Native OLEDB\Microsoft Office 12.0 Access Database Engine OLEDB Provider

    FileName or ServerName where your 2007 Access DB Located then provide the valid credentials à Test Connection

    Any one experienced the solution for this.. ?

    Thanks a Million in Advance!

    Tuesday, August 9, 2011 9:36 PM

All replies

  • If your envirnment is 64bit environment, you may try to changeg your Project's Run64BitRuntime property to false in Debugging section and re-try.

    This posting is provided "AS IS" with no warranties, and confers no rights.

    Wednesday, March 21, 2012 9:02 AM