The database file cannot be found. Check the path to the database

Question

0.00/5 (No votes)

See more:

Hi Friends,..
I got The following Error,
The Actual Error is

Error:The database file cannot be found. Check the path to the database. [ Data Source = \Program Files\database\sample3.sdf ]

I used VS 2008 sp1, SQL Server 2008 and Windows Mobile 6.0 for developing Windows Mobile Application.I got the Above Error.It is correctly Working in(View->ServerExplorer->Add Connection) but I did disconnected approach.i got the error and so i copied my application(database)and db(sample3.sdf)into the (C:\Program Files)i got the error..Please give me the correct solution for my problem..Thx

Posted 19-May-11 1:54am

Narayanan19

Updated 19-May-11 20:27pm

v3

Add a Solution

Comments

ZeeroC00l 19-May-11 8:36am

If the db file is in C:\Program Files why does the source contain \Program Files\database\ in the path ?

ZeeroC00l 19-May-11 8:36am

--edited for readability

1 solution

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 · 2011-05-19T02:57:00

Check the database exists, and that you have indeed pot it in the right place. (You should not really keep datafiles under the "Program Files" folder - consider "My Documents" instead).

In Visual studio, open the Server Explorer pane (View..Server Explorer)
If your database is listed, then it's location will be in the "Connection string" parameter in the Parameters pane if you highlight it.

If it isn't listed, right click Data Connections, then click Add New Connection and browse to it. You can check it is there and working from this dialog.