Connection string and web.config
From: Fernando Poinho Malard (fernando_at_graphsystem.com)
Date: 05/04/04
- Next message: Cor Ligthert: "Re: Popup Window"
- Previous message: David Jessee: "Re: Use URLEncode"
- Next in thread: Ken Cox [Microsoft MVP]: "Re: Connection string and web.config"
- Reply: Ken Cox [Microsoft MVP]: "Re: Connection string and web.config"
- Reply: George Ter-Saakov: "Re: Connection string and web.config"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 4 May 2004 09:19:15 -0300
Hello,
I'm developing a website which has a SQL database working through ADO.NET.
When I'm development site I have my personal IIS server as well as my
personal SQL server.
All my connections strings are pointing to this local SQL server.
When I need to upload the modifications to running website I have to
manually change all SQL connections strings because the running SQL server
is placed on other machine and has a different name.
To minimize this extra job I put my connection string into a key inside
web.config file but, even doing this, on all upload job I need to configure
this file.
Another similar problem is related to design time which uses also a
connection to my local SQL server for some DataSet and DataAdapter objects.
When another developer tries to edit these objects it receives an error
message due the same reason, his local SQL server has another name.
How can I make this easier than that?
Is there any way to solve this?
Kindest regards,
Fernando.
- Next message: Cor Ligthert: "Re: Popup Window"
- Previous message: David Jessee: "Re: Use URLEncode"
- Next in thread: Ken Cox [Microsoft MVP]: "Re: Connection string and web.config"
- Reply: Ken Cox [Microsoft MVP]: "Re: Connection string and web.config"
- Reply: George Ter-Saakov: "Re: Connection string and web.config"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
