After Installation problem

Question

0.00/5 (No votes)

See more:

Good afternoon sir,
I m Dinesh..
i m creating a project in ADO.NET with SQL server 2005 as a back end..
i have a question that after deploying my project for installation on OTHER machine..will my program give me error if destination machine server name does not match with my server name which i have used in my application..??

i used this code:

Data Source=Dinesh; Initial Catalog=college_Management_System; User ID=sa; Password=*****;

plz reply me sir soon...Confused | :confused:

Dinesh92

Posted 5-Feb-12 22:14pm

Dinesh92

Updated 5-Feb-12 22:36pm

Michel [mjbohn]

v2

Add a Solution

2 solutions

Solution 2

You will surely get an error if the name doesn't match. At least you'll see "Cannot connect to xyz" or s.th. similar.
Use a config file to store all DB credentials.

I'd suggest you start reading here:Managing Application Settings[^]

regards
Michel

Posted 5-Feb-12 22:33pm

Michel [mjbohn]

Comments

[no name] 6-Feb-12 8:16am

so..will i have to change my code (i.e Data source=xyz; Initial catalog=pqr;....) according to destination machine configuration...???

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-02-05T22:31:00

Solution 1

Yes.
You have to refer to the correct SQL Server instance, or it will fail.
Normally, you would but this into a configuration file, so that you do not have to change your code for each installation.

Posted 5-Feb-12 22:31pm

OriginalGriff

Comments

[no name] 6-Feb-12 8:17am

so..will i have to change my code (i.e Data source=xyz; Initial catalog=pqr;....) according to destination machine configuration...???

OriginalGriff 6-Feb-12 8:25am

Yes.

[no name] 6-Feb-12 8:29am

but how...???
because i have created an installation file of that application...

OriginalGriff 6-Feb-12 8:32am

As I said: "Normally, you would but this into a configuration file, so that you do not have to change your code for each installation." The installation program should locate the DB server and set the configuration data.

[no name] 6-Feb-12 8:39am

suppose i have created my installation file according to my machine server configuration (i.e. Data source=Dinesh and etc etc..)..and i m going to install on another machine on which the SQL server is already installed...and then if i install my application on that machine and i run it...will i still get an error...????

OriginalGriff 6-Feb-12 8:42am

Probably yes. Unless the machine and SQL server instance have the same name as your development ones...

[no name] 6-Feb-12 8:50am

can you tell me...how to overcome this problem...???

OriginalGriff 6-Feb-12 9:08am

Change your installation file?

[no name] 6-Feb-12 9:13am

ok..if it is last and the only way...i will have to do this...