Visual Studio 2008 Connection Strings

[Bondizzo]

Currently having a small problem, how do I set the connection string to be user specific in VS2008. I have a Solution that consists of 2 projects and I want both projects to use the same data source, at the moment its hard coded as an application setting so the system crashes when installed on another pc.

 

[Jacklondon]

Not sure

Maybe this could help.

http://stackoverflow.com/questions/1233212/visual-studio-solution-shared-data-source-for-report-projects

 

[Necuno]

there is always this
http://www.connectionstrings.com/

 

[Bondizzo]

Still cant find a proper answer, not even with with google.

 

[guest2013-1]

Yo, "user specific"... does this mean each user would have their own SQL Express installed?

 

[Bondizzo]

VS2008 wont let me set a user specific connection string, there will be one server and everyone connects to that server/database. Is it okay if its hard coded then ?

 

[Necuno]

maybe you should explain the following in detail so that we can give you a good solution.

a) what you want to accomplish exactly
b) the setup you are using to do this
c) user specific ? more detail...

 

[guest2013-1]

What is a "user specific connection string"?

If there is 1 server you want it to connect to why go user specific? Unless you have tons of money and time to setup SQL Server for each and every user that will ever access your program, then no.

app.config file --> it's like web.config file. throw the connection string in there, let the program read off of app.config and then if you ever do need to change it you don't need to recompile anything, just replace the .config.