• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1786
  • Last Modified:

Connection String Problem (C# VS2012, Access 2013, .Net 4.5)

I have a VS2012 C# app with build platform x64, database is Access (.MDB) from previous generations of the application.  When I have Access 2013 64-bit installed on the W7 64-bit system, everything is wonderful.  With Access 2013 32-bit installed on the same system, it throws an error when executing the "DBConnection.Open();".  The connection string is set to "Provider=Microsoft.ACE.OLEDB.12.0;Data Source="C:\Temp\CE.mdb";Jet OLEDB:Database Password=xyz;".  I also have the Access Database Engine 2010 installed (Office 14) in addition to the Office 15 install.

Any advice on how to resolve this problem will be greatly appreciated.
                DBConnection.ConnectionString = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=""" +
                    m_DatabaseParms[(int)DatabaseType.DT_ClientDB].DatabasePath +
                    @""";Jet OLEDB:Database Password=xyz;";

                    //  Open the connection

                    MessageBox.Show("Incorrect Access Driver Installed!  You are using connection string:\n\t" +
                        DBConnection.ConnectionString, "Error - Access Connection String", MessageBoxButtons.OK, MessageBoxIcon.Error);
                    throw new DatabaseException();
1 Solution
ariggs1042Author Commented:
OK, so I am dumb!  The fix for my problem was to install the Microsoft AccessDatabaseEngine_x64 with the Office 2013 32-bit.  It works well now.  Sorry no points on this one.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get 10% Off Your First Squarespace Website

Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to Squarespace.com and use offer code ‘EXPERTS’ to get 10% off your first purchase.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now