Connection string for ms Access in Ms winforms application

Question

Everything is perfect in this connection string according to my knowledge.But its not working fine.I'll be very thankful if someone helps me out to sort out this issue.Thanks

   string constr = "**Provider=Microsoft.ACE.OLEDB.4.0; Data Source=Data Source=F:/Database1.accdb;Persist Security Info=False**"; 
System.Data.OleDb.OleDbConnection conn = new System.Data.OleDb.OleDbConnection(constr);

Data Source=Data Source=F:/Database1.accdb <= Data Source=F:\Database1.accdb — 4dmonster
– 4dmonster, Commented Oct 28, 2013 at 11:41

Gord Thompson · Accepted Answer · 2013-10-28 11:57:31Z

1

Your current connection string has multiple issues. Try this instead:

string constr = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=F:\Database1.accdb;Persist Security Info=False";

answered Oct 28, 2013 at 11:57

Gord Thompson

125k38 gold badges251 silver badges458 bronze badges

Sign up to request clarification or add additional context in comments.

7 Comments

user2927881 Over a year ago

still it is giving error.." microsoft.ace.oledb.12.0' provider is not registered on the local machine c#".. i have installed it but still its giving same error..

Gord Thompson Over a year ago

@user2927881 It sounds like the version you installed does not match the "bitness" of your application. For example, if you are running a 64-bit application then you need the 64-bit version of the Access Database Engine.

user2927881 Over a year ago

"64-bit version of the Access Database Engine" was missing..i have installed it but now when i try to add its .DLL . Error is poping up and system is not letting me to add this refrence.how it can be sorted out???

user2927881 Over a year ago

On 64-bit versions of Windows look for the below paths: 64-bit - "C:\Program Files\Common Files\Microsoft Shared\OFFICE14\ACEOLEDB.DLL" i am trying to add this refrence..but its giving error...

user2927881 Over a year ago

its working now..by clicking on option of AnyCpu..Thanks a lot for your response..

|

Collectives™ on Stack Overflow

Connection string for ms Access in Ms winforms application

1 Answer 1

7 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

7 Comments

Your Answer

Sign up or log in

Post as a guest

Related