Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • World
  • Users
  • Groups
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse
Code Project
CODE PROJECT For Those Who Code
  • Home
  • Articles
  • FAQ
Community
  1. Home
  2. Database & SysAdmin
  3. Database
  4. coding for a software which is gonna run on a server [modified]

coding for a software which is gonna run on a server [modified]

Scheduled Pinned Locked Moved Database
databasequestioncsharpsql-servervisual-studio
4 Posts 4 Posters 0 Views 1 Watching
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • M Offline
    M Offline
    mrkeivan
    wrote on last edited by
    #1

    Hey guys, I'm writing a software which is going to be run on a server and accessed by around 5, 10 clients. I'm using visual studio 2008 + SQL Server 2005 I wanted to get some tips before I start coding, like how to figure out sqlserver connection cause the software installed on the clients is going to connect to the server probably using an IP address. what is best method of using database, cause this isn't meant for one place and I don't want to customize it everything, should I have a field for getting the IP address of the server ? or any other hint that might come handy in the future, if u got any links, tutorials, etc that would be great. Thanx K1

    modified on Tuesday, April 6, 2010 8:17 AM

    R D 2 Replies Last reply
    0
    • M mrkeivan

      Hey guys, I'm writing a software which is going to be run on a server and accessed by around 5, 10 clients. I'm using visual studio 2008 + SQL Server 2005 I wanted to get some tips before I start coding, like how to figure out sqlserver connection cause the software installed on the clients is going to connect to the server probably using an IP address. what is best method of using database, cause this isn't meant for one place and I don't want to customize it everything, should I have a field for getting the IP address of the server ? or any other hint that might come handy in the future, if u got any links, tutorials, etc that would be great. Thanx K1

      modified on Tuesday, April 6, 2010 8:17 AM

      R Offline
      R Offline
      R Giskard Reventlov
      wrote on last edited by
      #2

      Don't cross post: you have the exact same question in the c# forum. Delete one or the other before they both get removed.

      me, me, me "The dinosaurs became extinct because they didn't have a space program. And if we become extinct because we don't have a space program, it'll serve us right!" Larry Niven

      1 Reply Last reply
      0
      • M mrkeivan

        Hey guys, I'm writing a software which is going to be run on a server and accessed by around 5, 10 clients. I'm using visual studio 2008 + SQL Server 2005 I wanted to get some tips before I start coding, like how to figure out sqlserver connection cause the software installed on the clients is going to connect to the server probably using an IP address. what is best method of using database, cause this isn't meant for one place and I don't want to customize it everything, should I have a field for getting the IP address of the server ? or any other hint that might come handy in the future, if u got any links, tutorials, etc that would be great. Thanx K1

        modified on Tuesday, April 6, 2010 8:17 AM

        D Offline
        D Offline
        David Mujica
        wrote on last edited by
        #3

        Typically, you connect an application to a database server using a "connection string". This connection string contains the NAME of the server, not the IP address; by doing this your network administrator could change the IP address of your server and your application would not have to change. A DNS server can be used to provide the layer of abstraction between an IP address and the name of a server. Refer to: DNS Defined: http://technet.microsoft.com/en-us/library/cc787920(WS.10).aspx[^] Connection Strings: http://www.connectionstrings.com/[^]

        P 1 Reply Last reply
        0
        • D David Mujica

          Typically, you connect an application to a database server using a "connection string". This connection string contains the NAME of the server, not the IP address; by doing this your network administrator could change the IP address of your server and your application would not have to change. A DNS server can be used to provide the layer of abstraction between an IP address and the name of a server. Refer to: DNS Defined: http://technet.microsoft.com/en-us/library/cc787920(WS.10).aspx[^] Connection Strings: http://www.connectionstrings.com/[^]

          P Offline
          P Offline
          PIEBALDconsult
          wrote on last edited by
          #4

          Until the DNS server dies and your app won't run until it's replaced. I wrote my own little network name cache/resolve system to handle that problem after I got bit.

          1 Reply Last reply
          0
          Reply
          • Reply as topic
          Log in to reply
          • Oldest to Newest
          • Newest to Oldest
          • Most Votes


          • Login

          • Don't have an account? Register

          • Login or register to search.
          • First post
            Last post
          0
          • Categories
          • Recent
          • Tags
          • Popular
          • World
          • Users
          • Groups