Post reply

Jet OLEDB 4.0 connection on 64 Server.

  • May 21, 2009 at 7:43 am

    #209894

    We have developed a SSIS package which uses Microsoft.Jet.OLEDB.4.0 to open Excel file.

    This package runs from a job on a 32 bit test server without any problem.

    But, while running this package from a job on a 64 bit server, it throws following error:

    Description: The connection "Provider=Microsoft.Jet.OLEDB.4.0" is not found. This error is thrown by Connections collection when the specific connection element is not found. End Error DTExec: Could not find the Provider=Microsoft.Jet.OLEDB.4.0 connection in the package.

    How to fix thhis problem? It is Jet driver issue? What is meant by "connection is not found"?

    I searched and found that Microsoft has not provided 64 jet driver. However, it looks like there is workaround for this problem.

    Any help will be highly appreciated.

  • May 21, 2009 at 8:09 am

    #998281

    I have posted this again under SQL Server 2005 Integration Services.

    I tried to delete this post, but it is not getting deleted.

  • May 21, 2009 at 8:19 am

    #998294

    Threads can't be deleted.

    No replies here please. Direct replies to http://www.sqlservercentral.com/Forums/Topic721366-148-1.aspx

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 3 posts - 1 through 2 (of 2 total)

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