Connection string problem

Question

0.00/5 (No votes)

See more:

Hi i am facing one problem in setting connection string
In my one project during set up project i have set my connection string to

Dim constr As String = "Data Source=.\SQLEXPRESS;AttachDbFilename=" + Application.StartupPath + "\DB\NDA.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True"

where DB is folder name,
with the help of this i need not install database to client machine

but this connection string giving problem in App.config file and giving error on Application.StartupPath word
what should be reason and solution for that

Posted 7-May-11 0:52am

Mayur Gujrathiii

Add a Solution

Comments

OriginalGriff 7-May-11 7:02am

What error is it giving?

Ankur^\m/ 7-May-11 7:08am

OP wrote:
it is giving error on Application.StartupPath word key word not found

Mayur Gujrathiii 7-May-11 7:06am

it is giving error on Application.StartupPath word key word not found

NuttingCDEF 7-May-11 7:21am

Compiler error or runtime error?

Mayur Gujrathiii 7-May-11 7:44am

compile time error

Ankur^\m/ 7-May-11 7:08am

Do you want us to GUESS the error you are getting and give you a solution. Add the error details to your question by selecting 'Improve Question' link.

Mayur Gujrathiii 7-May-11 7:18am

Ankur i have already stated there first read and then comment any thing

NuttingCDEF 7-May-11 7:25am

I suspect that Ankur may have been posting his comment simultaneously with you posting the error details - and then realised what had happened (see his reply to OriginalGriff's comment) - such are the perils of collaborative real time working :-)

3 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 · 2011-05-07T01:16:00

Solution 1

The only reason I can think of for that is if you are trying to use it in a class or application which does not reference Windows.System.Forms. Is this a Web application, at all?

Posted 7-May-11 1:16am

OriginalGriff

Comments

Mayur Gujrathiii 7-May-11 7:41am

yes it is windows application

OriginalGriff 7-May-11 7:49am

Does it change at all if you make the reference explicit?
Dim constr As String = "Data Source=.\SQLEXPRESS;AttachDbFilename=" + System.Windows.Forms.Application.StartupPath + "\DB\NDA.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True"

What happens if you take out the two fixed strings - just for testing - do you still get the error?

NuttingCDEF · Answer 2 · 2011-05-07T01:16:00

See http://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqlconnection.connectionstring(v=vs.71).aspx[^] for valid key words.

This doesn't list User Instance - so might that be an issue?

If so, see also http://social.msdn.microsoft.com/Forums/en-US/sqlgetstarted/thread/45700f5c-59ba-41cd-ac59-46873f26845a/[^] which gives further info on User Instance and how to get it working.

Never tried it myself, but someone there thinks they found a solution.

Hope this helps.

NuttingCDEF · Answer 3 · 2011-05-07T03:19:00

Solution 3

You have "Dim constr As String " - that looks like VB not C# - if so, isn't the correct string concatenation operator "&" and not "+"?

Posted 7-May-11 3:19am

NuttingCDEF