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 Post Reply

1063

Cor Ligthert[MVP]

Manish,

How would you think that was going, there are millions of SQL servers on the
world, and if there is an Internet connection you can in fact connect to
all. How would you want to connect them without telling which it was?

Cor

Mar 12 '08 #2

Andrew Morton

Manish wrote:

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.]

You could install another instance of SQL Server.

Andrew

Mar 12 '08 #3

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...

.NET Framework

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

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...

ASP.NET

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...

C / C++

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...

Javascript

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; ...

Javascript

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...

.NET Framework

Allowing Make Table Query overwriting existing table in mdb via adodb connection

by: arcingmad | last post by:

Hi I am using the following code in a button click event to run a query stored in a .mdb file from an external geographic program ArcGIS via a jet adodb connection I have the need to run an...

Visual Basic 4 / 5 / 6

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...