HighTechTalks DotNet Forums  

Changing a Datasource's ConnectionString in VS 2005

Dotnet Data Tools microsoft.public.dotnet.datatools


Discuss Changing a Datasource's ConnectionString in VS 2005 in the Dotnet Data Tools forum.



Reply
 
Thread Tools Search this Thread Display Modes
  #1  
Old   
Jeff
 
Posts: n/a

Default Changing a Datasource's ConnectionString in VS 2005 - 12-14-2005 , 09:13 PM






What's the easiest way of changing the connection string associated with a
'datasouce' in VS 2005? I would assume that I can delete the .xsd file and
start over, but that certainly seems like a sledge hammer. I change the
string in the app.config file with no effect. Seems that the connection
string is "baked in" to the dataset after the initial creation?!?

i.e. How do I change between development and production databases through
configuration? Certainly, I have to be missing something!

New to 2005 if you couldn't tell...I really like the enhancements! Great
stuff...

Thanks in advance for your help...
--
Jeff Block

Reply With Quote
  #2  
Old   
Michael Nemtsev
 
Posts: n/a

Default Re: Changing a Datasource's ConnectionString in VS 2005 - 12-15-2005 , 03:24 PM






Hello jeff,

Maybe I missed smth, but why u can't change connection string in the Server
Explorer pannel (right side in VS)

j> What's the easiest way of changing the connection string associated
j> with a 'datasouce' in VS 2005? I would assume that I can delete the
j> .xsd file and start over, but that certainly seems like a sledge
j> hammer. I change the string in the app.config file with no effect.
j> Seems that the connection string is "baked in" to the dataset after
j> the initial creation?!?

---
WBR,
Michael Nemtsev :: blog: http://spaces.msn.com/members/laflour

"At times one remains faithful to a cause only because its opponents do not
cease to be insipid." (c) Friedrich Nietzsche



Reply With Quote
  #3  
Old   
Jeff
 
Posts: n/a

Default Re: Changing a Datasource's ConnectionString in VS 2005 - 12-15-2005 , 03:40 PM



Michael,

You might be able to, but I also found an easier way. Under the project
properties and then "Settings"! bingo, this was the magic in my case.

--
Jeff Block


"Michael Nemtsev" wrote:

Quote:
Hello jeff,

Maybe I missed smth, but why u can't change connection string in the Server
Explorer pannel (right side in VS)

j> What's the easiest way of changing the connection string associated
j> with a 'datasouce' in VS 2005? I would assume that I can delete the
j> .xsd file and start over, but that certainly seems like a sledge
j> hammer. I change the string in the app.config file with no effect.
j> Seems that the connection string is "baked in" to the dataset after
j> the initial creation?!?

---
WBR,
Michael Nemtsev :: blog: http://spaces.msn.com/members/laflour

"At times one remains faithful to a cause only because its opponents do not
cease to be insipid." (c) Friedrich Nietzsche




Reply With Quote
Reply




Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.4
Copyright ©2000 - 2009, Jelsoft Enterprises Ltd.