How to connect to .sdf file in a desktop application

Question

0.00/5 (No votes)

See more:

Hi,
I have developed a desktop application but there is Local Based Server means .sdf file as a database. When I want to connect through:

I have connection in APP.config file and

SqlConnectionstring con=new sqlConnection()
con.Open()

This got an network related error message:

A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)".

How to connect to Local based server? How to Solve this Problem?

Posted 7-Mar-13 4:39am

Shafiqur Rahman, Banladesh

Updated 7-Mar-13 5:32am

Mike Meinz

v6

Add a Solution

Comments

joshrduncan2012 7-Mar-13 10:45am

You need to tag your posts correctly. There is a tag for Sql Server Compact Edition (which are the .sdf files).

Also, you are creating a connection, but not pointing to the .sdf file, so the compiler doesn't know where the .sdf file is located to connect to.

Shafiqur Rahman, Banladesh 7-Mar-13 10:58am

I have appconfig file and I have debug and found connectionstring (location of sdf file) in debugging mode.

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)

Mike Meinz · Accepted Answer · 2013-03-07T05:05:00

You must put the ConnectionString into the SQLCEConnection object before you Open the connection.

See
SQLCEConnection Constructor[^] for an example.

Example of how to retrieve ConnectionString by Name
Example: Retrieving a Connection String by Name[^]

Other documentation about getting ConnectionString from config file
Configuration.ConnectionStrings Property [^]
Configuration.AppSettings Property[^](Obsolete)

Richard MacCutchan · Accepted Answer · 2013-03-07T05:37:00

Solution 2

The above code would not even compile (your class types are wrong), and you are missing the actual connection string; your code should be something like:

C#

SqlCeConnection con = new SqlCeConnection(Properties.Settings.Default.DBConnection);
con.Open();

Posted 7-Mar-13 5:37am

Richard MacCutchan

Comments

Mike Meinz 7-Mar-13 13:19pm

My 5 and Thanks for pointing out SQLCEConnection should be used. I changed Solution 1 to use SQLCEConnection.

BTW. The syntax for the SQLCEConnection Constructor allows no parameters. See SQL CEConnection Constructor

Richard MacCutchan 7-Mar-13 13:30pm

See also SqlCeConnection Constructor (String).

Richard MacCutchan 7-Mar-13 13:30pm

Oops, forgot to say thanks for the vote.