|
Hi there!!
My problem is when i am switching to another SQL SERVER with my project then every time i have to change my connection string.
Is there any way to solve this problem??
|
|
|
|
|
KIDYA wrote: My problem is when i am switching to another SQL SERVER with my project then every time i have to change my connection string.
Why is that a problem? Surely you are storing your connection string in the config file. Or have you hard coded it in to the application itself?
Man who stand on hill with mouth open wait long time for roast duck to drop in
|
|
|
|
|
I have it in config,Now tel me other way.
Please!!! 
|
|
|
|
|
KIDYA wrote: I have it in config,Now tel me other way.
What specific problem do you have with having the connection string in your config file?
Man who stand on hill with mouth open wait long time for roast duck to drop in
|
|
|
|
|
i want common connection string thr' which i can run my project on any server withput changing config connection string.
|
|
|
|
|
..and how will you know how the SQL-server instance on my PC is called?
I are troll 
|
|
|
|
|
you can store such information in a database!
Luc Pattyn [Forum Guidelines] [My Articles]
The quality and detail of your question reflects on the effectiveness of the help you are likely to get.
Show formatted code inside PRE tags, and give clear symptoms when describing a problem.
|
|
|
|
|
Telepathic software, the next wave of future development, just think about where you want to be!
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
Tele: meaning remote
Pathetic: standing for the quality
|
|
|
|
|
You can have several connection strings in the same config file. You can design your application in such a way that it prompts the user to select which environment it wants to connect to and then fetch the appropriate connection string from the config file.
|
|
|
|
|
Assume you booked a Air Ticket for California. Now you have changed your mind and decided to go to Paris. What do you think, the same ticket will work? Sorry, just kidding. If you are changing the database, the connectionstring also needs to be changed either in config file or in every places where it is used.
Regards
Saanj
Either you love IT or leave IT...
|
|
|
|
|
I think what you are looking for is "localhost".
If you set the server name in the connection string to "localhost" it will connect to the SQL server running on the local PC.
You need to explain your question in more detail and explain what you are trying to do, your question is not clear at all.
Simon
|
|
|
|
|
Thanx dude!! u only gave my answer. 
|
|
|
|
|
My pleasure.
The reason that you didn't get any other good answers is because you question was very unclear and difficult to understand.
I'm not talking about the quality of your English (that's fine), but about how well you describe your problem. Next time you post a question, take the time to properly describe the situation you are in, the problem you are having, and what you are trying to achieve.
Simon
|
|
|
|
|
KIDYA wrote: My problem is when i am switching to another SQL SERVER with my project then every time i have to change my connection string.
That will always be the case.
The only solution, that I can think of, there may be others but they escape me for now.
1. Try connecting using your stored connectionstring, catch exceptions and when the exception shows database absent
2a. Create a clone of the MS Server Connection Dialog and let the user 'find' the right server. OR
2b. Iterate over all available servers and do 1. above uon each one ntil you find the database, then modify the current connectionstring to match.
You might find it useful to read up on the ConnectionStringBuilder class for a fairly easy way to modify connection strings.
You might also want to download the SQLServer 2008/2005 Samples from Microsoft Download site for an example of cloning the dialog. If you do so an example will be found at YourDrive:\YourBaseDirectory\Samples\Engine\Programmability\SMO\ServerConnect\CS\ServerConnect.
In the Samples directory tree you will also find examples of how to find all available servers, so you can iterate over them, if you decide to do it that way.
Of course whichever way you do it, you will be faced with the problem of how and where to store the modified connection string.
Good Luck!
Henry Minute
Do not read medical books! You could die of a misprint. - Mark Twain
Girl: (staring) "Why do you need an icy cucumber?"
“I want to report a fraud. The government is lying to us all.”
|
|
|
|
|
Hello Experts!!
During adding records into datagridview i want to prevent duplicate values adding,i am saving multiple values at a time.when i enter duplicate value into specific column then it must show msg for same.
now i am using cell changed event.
|
|
|
|
|
Set the constraint on the column in the DB itself.
जय हिंद
|
|
|
|
|
|
can you please provide source code to prevent entering duplicate values in mysql using aspx
|
|
|
|
|
Can any body let me know how to create connectivity between two/three systems actualy we developed dotnet application and database is sql server 2000 if try to connect its displaying following Error.
"An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 25 - Connection string is not valid)"
|
|
|
|
|
Check ur connection string.which authentication u r using for SQL SERVER.if ur using local then just change old connection string with ur workign SQL SERVER.
|
|
|
|
|
KIDYA wrote: Check ur connection string.which authentication u r using for SQL SERVER.
The error message indicates that the issue is with establishing a connection, not with authenticating a connection.
Man who stand on hill with mouth open wait long time for roast duck to drop in
|
|
|
|
|
this site[^] is the haven for connection strings.
Yours needs work.
|
|
|
|
|
I have a file "vnspeech.dll",it have function "int VietUniTTS(wchar_t*)".How use this function with C#?????
Thanks!
|
|
|
|
|
I want IE to navigate through a PDF file which is on desktop when a PDF file's URL is obtained in the addressbar,
object empty = System.Reflection.Missing.Value;
webBrowser.Navigate(DesktopFilePath, ref empty, ref empty, ref empty, ref empty);
if I continuously open some url's like http://somesite.pdf, then the IE continuously navigates through the PDF file which
is on desktop(i.e., c:\currentUser\desktop\123.pdf), after sometime if I try to navigate some other links IE gets hanged,
How can I solve this?
I was doing all this through a BHO, when a DocumentComplete Event is fired using c#.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
