Originally Posted by raj_55555
Thanks a lot sir for the link.
My problem is that I have no experience at all in network programming. Now if I want to build a database application using C# I am getting choked at some (maybe obvious) areas. Let me give an example:
In this, I dont understand where do I get the serveraddress?
:) This is a common problem. Working out the the correct parameters for any configuration issues is a *&(%(&^%(*& and DB connection strings can be confusing for exactly these reasons. So don't feel bad. No matter how much experience you get, you (and all the rest of us) will always cringe a little when you need to work with connection strings. The day you don't mind is the day you've become a hardcore DBA / server admin.
server is used in a couple of my connection strings. On my development box where I use VWD's built-in web server to view my sites, the web.config files give the parameter as
I should note that this is also how the web server displays my website. My root folder for the application is webroot so whenever I access a page in the browser, the address bar reads "http://localhost:1420/webroot/Somepage.aspx".
In the version of the web.config that runs on my production server (I keep both around as WebDev.config and WebProduction.config, and the copy the one I need to Web.config depending on which server I'm on. I find this really easy.), I have server set to the computer name which was provided by my hosting company, it's something like "db42.brinkster.com". I'll note that it was not part of my control panel. While the DB was provided "automatically" as part of my package, I had to call the tech support guys and they turned it on before I could use it (in fact, before the appropriate server name would even display in my control panel). So you may need to call them. This was just one of the many times I've been glad that I called all the tech support lines for the hosting companies I was looking at. After deciding which ones had the features I wanted in the price range I was looking for, I made my final decision based on who had the best tech support... best. decision. ever. :)