When I Install My Window Form Application Another Machine Database Not Connected

Question

0.00/5 (No votes)

See more:

sir plz help me when i install my window form application another machine database not connected

ERROR:-

ASM

Unhandle Exception has occurred in your application. 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 connection(provide: SQL network interfaces, error:-26 ERROR locatings server/intance specified)

Posted 1-Sep-14 19:56pm

Nishant.Chauhan80

Add a Solution

Comments

Herman<T>.Instance 2-Sep-14 1:58am

how does your connectionstring match the real database?

Nishant.Chauhan80 2-Sep-14 2:08am

how to modify connection another machine

syed shanu 2-Sep-14 2:02am

Where do you Install.Is the Connection string match to your present installed computer.is Db in same computer or in Network.is your connection string in your application is hardcoded or you can edit it

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 · 2014-09-01T20:39:00

The chances are that you have hardcoded your connection string - included it as a string in your source code - and that the first thing you need to do is change that to use a configuration file of some description.

The simplest is to use the Settings.Settings file:
1) Open your projects Properties in the solution explorer, and double click on "Settings.settings"
2) In the resulting grid, change the Name to "MySetting", and set the Value to "Defaulted value". Leave Type and Scope as "string" and "User" respectively.
3) Save and close the settings window.
4) To read your setting:

string s = Properties.Settings.Default.MySetting;

5) To write your setting:

Properties.Settings.Default.MySetting = "My new setting value";
Properties.Settings.Default.Save();

Then you need to provide a mechanism for changing the configuration file so that you can set the appropriate connection string for the new environment. What that will be we can't say: most development SQL server instances tend to use Windows authorisation for log in, while production ones are generally username and password protected - you will have to find out from the db admin what the string should be.

MukeshSagar · Answer 2 · 2014-09-01T20:40:00

Solution 2

First of all check which database you are using. If it is SQL Server then check the database connection string.

The best way is to use the inbuild database which will not create any issue regrading the changing the connection string.

Posted 1-Sep-14 20:40pm

MukeshSagar