none
The 'Microsoft.Jet.OLEDB.4.0' provider is not registered on the local machine. RRS feed

  • Question

  • HI,

    Plz Help on my below error.

    ______________________________________________________________________

    The 'Microsoft.Jet.OLEDB.4.0' provider is not registered on the local machine.

    System.Data
    Void GetDataSource(System.Data.OleDb.OleDbConnectionString, System.Data.OleDb.DataSourceWrapper ByRef)

    ______________________________________________________________________

    I am developing Program in Vb.net (visual Studio 2005) and connecting a Microsoft access database .mdb file.

    and my connection string was below:

    "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Application.StartupPath & "\Attachments\DSI.mdb;JET OLEDB:Database Password=123;Persist Security Info=True "

    FYI.. OS : Windows 7 (64 bit)

     am trying so many time what is solutiuon?

    _______________________________________________________________________

    Thursday, June 26, 2014 11:53 AM

Answers

  • Hi Lalit,

    If we are suing Microsoft.Jet.OLEDB 4.0 driver in a 64 bit server, we have to force our app to build in 32 bit mode. Fortunately, Microsoft has released a 64 bit compatible 2010 Office System Driver which can be used as replacement for Jet driver. It works both in 32 bit as well as 64 bit server. Please refer to download this drive from http://www.microsoft.com/en-us/download/details.aspx?id=13255.

    Regards,


    We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
    Click HERE to participate the survey.

    Friday, June 27, 2014 6:08 AM
    Moderator