sql error 26

Question

0.00/5 (No votes)

See more:

hello

I have error in the connection to Sql server in C# program

this is the code of connection

C#

SqlConnection connection = new SqlConnection();
connection.ConnectionString = 
@"Data Source=D:\NewCode\DataBaseWin.sdf;Integrated Security=SSPI";
connection.Open();

and this is the error

provider sql network interfaces error 26 - error locating server/instance specified

what I have to do ?
Oo

Posted 7-May-12 7:58am

maxpower12345

Add a Solution

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 · Accepted Answer · 2012-05-07T08:07:00

Solution 1

Why are you using an SqlConnection to connect to an SDF file? Why not use an SqlCeConnection?

C#

SqlCeConnection connection = new SqlCeConnection();
connection.ConnectionString = 
@"Data Source=D:\NewCode\DataBaseWin.sdf;Integrated Security=SSPI";
connection.Open();

Posted 7-May-12 8:07am

OriginalGriff

Comments

maxpower12345 7-May-12 14:18pm

What is the differences between SqlConnection and SqlCeConnection ?

OriginalGriff 7-May-12 14:30pm

SqlConnection is intended to connect to databases managed by SQL Server - these are not normally referred to by an extension as the SQL server instance takes care of that (and a lot of other things) behind the scenes. These are generally multiuser (or you are downloading a lot of software for no real benefit).
SqlCeConnection connects only to .SDF files and works with them in a single user environment.

If yopu connect with SqlConnection, you must use SqlCommand and related objects, if you connect with SqlCeConnection, you use SqlCeComamnd and related objects instead.

Not trying to be rude, but why are you using an .SDF file if you don't know this?

maxpower12345 7-May-12 14:46pm

:$ Actually I thought its not diffident from mdf
:S oops

OriginalGriff 7-May-12 14:56pm

Nah, SDF is single user stuff created originally for WinCE devices - it's handy though, for well structured datafiles if you want to be able to work in a record based manner without having to re-write the file each time you insert or delete.
It also has a small footprint - the files needed to run it are tiny compared to MSSQL!

maxpower12345 7-May-12 15:33pm

Great >> so I have to make new database (mdf)
thanks for your help
I hope if make mdf will help to solve the error
thanks

Monjurul Habib 8-May-12 16:27pm

5!