When I try to connect my C sharp project to access 2010 it give error "could not find installable ISAM"

Question

0.00/5 (No votes)

See more:

When i try to connect my c sharp project to access 2010 it give error "Could not find installable ISAM" and i am using visual studio 2010. but when i use visual studio wizard for connection to database it works

Here is the code of App.config file.

<pre><configuration>
  <appSettings>   
    <add key="connection" value="Provider=Microsoft.ACE.OLEDB.12.0; DataSource=C:\\Users\\Varun\\Documents\\InventoryManagement.accdb"  /> 
  </appSettings>
</configuration>

code of Form1.cs file

using (OleDbConnection con = new OleDbConnection(ConfigurationManager.AppSettings["connection"]))
{
       con.Open();
       OleDbCommand cmd = new OleDbCommand("SELECT * FROM Logg",con);
       OleDbDataReader dr = cmd.ExecuteReader();
       while (dr.Read())
       {
             txtUserName.Text = dr["User_name"].ToString();
       }
}

What I have tried:

I tried changing platform target to x86, x64, any platform nothing works.

Posted 6-Aug-17 6:03am

varuncodee

Updated 6-Aug-17 6:29am

v2

Add a Solution

Comments

Michael_Davies 6-Aug-17 12:09pm

Is the Data; valid? and should'nt it be DATA SOURCE not DATASOURCE

Try;

<add key="connection" value="Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\\Users\\Varun\\Documents\\InventoryManagement.accdb" />

https://www.connectionstrings.com/access/

varuncodee 6-Aug-17 12:17pm

Still not working.

varuncodee 6-Aug-17 12:18pm

i tried visual studio wizard for connection and it works. But manually by code it's not working.

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

OriginalGriff · Answer 1 · 2017-08-06T06:27:00

Couple of problems here: check your ACE driver - if you are trying to use an office 2010 or higher DB, you need ACE OLEDB V14, not V12.
Second, "DataSource" in your connection string should be "Data Source", and the backslashes in your string should be single, not double. Double backslash is only needed when '\' is an escape character for your string such as in C# - not in config files.

You should be able to create a "working" connection string using a UDL file: Simple SQL Connection String Creation[^] - I know it works for SQL Server, but haven;t tried it for MDB files via ACE (and I don't have ACE installed on this machine).

varuncodee · Answer 2 · 2017-08-06T06:29:00

Solution 2

I just copy my access database from C: drive to D: drive and it works. I don't have admin right in C: drive.

Posted 6-Aug-17 6:29am

varuncodee

Comments

Dave Kreskowiak 6-Aug-17 12:53pm

Yep. In order to open an Access database in your application, the user running your code MUST have write permissions to the folder the database file is in.