The Connection String in Oledb

Question

0.00/5 (No votes)

See more:

Hi all

the below code is Connection String between Access 2010 and C#.net 2010
My Database have password.

C#

Access_Con = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=|DataDirectory|\L_Loan_Database.accdb;Jet OLEDB:Database Password=xxxx;

but I have following error

Can not open database ". It may not be a database that your application recognize, or the file may be corrupted.

I search in the Connectionstrings.com website but don't help me.

tanks a lots.

Posted 15-Mar-15 2:18am

bernova

Updated 15-Mar-15 2:29am

v2

Add a Solution

Comments

Kornfeld Eliyahu Peter 15-Mar-15 8:21am

Did you set DataDirectory?

bernova 15-Mar-15 8:55am

???????

bernova 15-Mar-15 9:26am

How to Set DataDirectory in the class library

bernova 15-Mar-15 8:30am

No How Do I?

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 · 2015-03-15T02:32:00

Solution 1

Try setting up a connection in VS with the Server Explorer pane:
1) Open Server Explorer.
2) Right click "Data connections" and select "Add connection"
3) In the dialog that follows, select your DataSource, and database, specify the security info, and press the "Test connection" button.
4) When the connection works, press "OK"
5) Highlight your database in the Server Explorer pane, and look at the Properties pane. A working example of the connection string will be shown, which you can copy and paste into your app or config file.

Posted 15-Mar-15 2:32am

OriginalGriff

Comments

bernova 15-Mar-15 8:45am

Tanks OriginalGriff.
because I set password on the access database . shows the same error.
My connection string is wrong.

OriginalGriff 15-Mar-15 8:55am

SO try what I suggested, and provide the right password! :laugh:

bernova 15-Mar-15 9:25am

My Question is
are the connection string is correct ?

bernova 15-Mar-15 9:27am

tanks. but Your solution shows the same error.

OriginalGriff 15-Mar-15 9:42am

Count to ten, Griff, count to ten...

No, it doesn't - not unless you are failing to connect to your DB when you follow the instructions. Did you press the "Test Connection" button, at all?

bernova 15-Mar-15 9:46am

yes I does your solution. but when click on the test connection shows the following error :

Can not open database ". It may not be a database that your application recognize, or the file may be corrupted.

OriginalGriff 15-Mar-15 10:55am

So start by looking at your database: does it exist exactly where you are telling VS?

Kornfeld Eliyahu Peter · Answer 2 · 2015-03-15T03:19:00

Solution 2

You are using |DataDirectory|, which is a placeholder for the actual directory. If not defined otherwise it will be mapped to your application's directory...
If you want the connection engine to look for a different path you should use

C#

AppDomain.CurrentDomain.SetData("DataDirectory", "[your path to the db file]");

Posted 15-Mar-15 3:19am

Kornfeld Eliyahu Peter

Updated 15-Mar-15 3:30am

v2

Comments

bernova 15-Mar-15 9:37am

thanks. I used same above code as following :
AppDomain.CurrentDomain.SetData("DataDirectory", Directory.GetCurrentDirectory());

I Write my Connection String in Class Library (dll). but I can't use above code and shows error