Results 1 to 4 of 4
  1. #1
    Philosophaie is offline Novice
    Windows Vista Access 2010 32bit
    Join Date
    Aug 2012
    Posts
    28

    Connection string error

    I am trying to connect to a Access database. I have setup in advance a Access db called "ToAccess.mdb".

    In Visual Studio 2013 I have setup in web.config this excerpt:
    Code:
    <connectionStrings>
        <add name="Accessdb" connectionString="Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Users\User\Documents\a Access\ToAccess.mdb;Persist Security Info=False;" />  
    </connectionStrings>
    In Server Explorer>Data Connections>Add Connection... I selected Data Source:
    Microsoft Access Database File (OLE DB)
    I selected my Access file: "C:\Users\User\Documents\a Access\ToAccess.mdb" and it came up on my Server Explorer. That was ok.

    I am having an error with my connection string:


    "System.InvalidOperationException: The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine. ".
    Any suggestions?

  2. #2
    LaughingBull is offline Competent Performer
    Windows 8 Access 2013
    Join Date
    Jul 2015
    Location
    Toledo Ohio
    Posts
    143
    that has to do with your software and the machine it is installed on. are you stand alone or on a server ?

    Sounds like your on a server and your machine does not recognize the MS access software that is on the server.

  3. #3
    Philosophaie is offline Novice
    Windows 8 Access 2010 32bit
    Join Date
    Aug 2012
    Posts
    28
    I have not put this db on my server. I am first learning how on my win8.1 Pro pc with localhost. It may be because I am working on Access 2016 Trial Version.

  4. #4
    LaughingBull is offline Competent Performer
    Windows 8 Access 2013
    Join Date
    Jul 2015
    Location
    Toledo Ohio
    Posts
    143
    yes that is it because it says the DB software is not registered to your PC so you need to get your own software and load it on your machine

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 2
    Last Post: 01-21-2015, 06:03 AM
  2. Replies: 2
    Last Post: 11-22-2013, 09:32 AM
  3. Connect System DSN using connection string
    By jbailey4545 in forum Access
    Replies: 0
    Last Post: 11-08-2013, 01:29 PM
  4. Create dynamic connection string to Access
    By janwane in forum Access
    Replies: 2
    Last Post: 10-07-2011, 06:56 AM
  5. Connection String
    By cradaa in forum Access
    Replies: 4
    Last Post: 05-24-2011, 07:28 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums