How to make common connection string for diff program?

Manish

Hi
i have a problem where as i want to use two different C# net program
in a single system where i have used 2 different sql server name. when
i execute those program each time iam renaming the sql server name and
executing the programs. Is there any way where i can write a
connection string without using a sql server name or is there any
other possibility to solve this problem.
[Note : i don't want to use the same sql serve name for both the
programs.]

Mar 11 '08 #1

Subscribe Reply

2058

=?Utf-8?B?TW9ydGVuIFdlbm5ldmlrIFtDIyBNVlBd?=

Hi Manish,

I fail to see your problem. You say you have two different C# applications,
and two different SQL server instances? Why do you need to rewrite anything
to run the programs? Or do you have a single SQL server instance and rename
this instance for each of the applications, with one application using one
instance name and the other application using another?! If the latter is
true why can't you use the same sql server name as the other program?

The connection strings should for each of the programs be put in a Setting
and available in the app/web.config file for the applications. You could
then either just rewrite the connectionstrin g for either of the applications,
or encrypt the connection string and maybe have the sql server instance name
in a separate setting and dynamically create the connectionstrin g at runtime.

If this doesn't answer your question, please clarify your problem with added
information.

--
Happy Coding!
Morten Wennevik [C# MVP]
"Manish" wrote:

Hi
i have a problem where as i want to use two different C# net program
in a single system where i have used 2 different sql server name. when
i execute those program each time iam renaming the sql server name and
executing the programs. Is there any way where i can write a
connection string without using a sql server name or is there any
other possibility to solve this problem.
[Note : i don't want to use the same sql serve name for both the
programs.]

Mar 12 '08 #2

Similar topics

281

SQL Connection failing on single NT machine

by: Steve | last post by:

I have installed an application out to about 15 machines. Some NT (service pack 6) and some Windows XP. They all work......except for one machine. It is an NT machine. I cant work out why it wont work on this machine. The error occurs when logging in. It complains that ExecuteReader is failing as the Connection is closed. My connection...

.NET Framework

2525

I want to make common connection string for database

by: Alex Smith | last post by:

Hi Friends I want to make common connection string for database. I can not use Web config file, so please give idea excluding web.config file. Thanks. Alex

C# / C Sharp

1498

Urgent: Need some advice on Connection

by: Mike L. | last post by:

Hi, Pls, beware that I'm new to this :) I've developed several web appl, either with ASP or ASP.NET. All using SQL server as the back end. In my development environment, I have a single server running Win2K, which serves as Web Server and SQL server as well. And, since my hosting (production server) using the same config; ie: using a...

ASP.NET

5802

Replacing a word in a string

by: jacob navia | last post by:

Hi guys! I like C because is fun. So, I wrote this function for the lcc-win32 standard library: strrepl. I thought that with so many "C heads" around, maybe we could improve it in a collective brainstorming session. Let's discuss some C here, for a change :-)

C / C++

4854

Can't make this page work

by: scottyman | last post by:

I can't make this script work properly. I've gone as far as I can with it and the rest is out of my ability. I can do some html editing but I'm lost in the Java world. The script at the bottom of the html page controls the form fields that are required. It doesn't function like it's supposed to and I can leave all the fields blank and it still...

Javascript

2420

a method to make js have the ability to inherit

by: zzw8206262001 | last post by:

Hi,I find a way to make javescript more like c++ or pyhon There is the sample code: function Father(self) //every contructor may have "self" argument { self=self?self:this; //every class may have this statement self.hello = function() {

Javascript

1871

How to make the app run?????

by: =?Utf-8?B?S2plbGw=?= | last post by:

Hello I've taken a four days training in C#, very good training, experienced teacher and all that, very positive. Went home spent a week making my first application, slightly more than the usual "Hello world". Took it with me to my best customer, and beleive it or not....It will not work !!!!

.NET Framework

2895

How to make (ptr + len) > lim safe?

by: Michael B Allen | last post by:

I like to use limit pointers as sentinels when working on buffers of data. Meaning I use ptr < lim where ptr and lim are both pointers rather than n 0 to determine if it is safe to proceed writing to that location. The rationale is that it is simpler and thus safer because you're not constantly recomputing integer n. However, I've run into...