sql server & web server on diff computers..how?

• khameleon

  Newbie

  Points: 1

  More actions

  April 15, 2003 at 1:24 pm

  #158873

  how do i connect from my webserver machine to the SQL server database which is on a diff machine. what do i do to connect..both machines are on the same network.

• dgermundson

  Hall of Fame

  Points: 3175

  More actions

  April 15, 2003 at 1:55 pm

  #454300

  Take a look at Help on Microsoft Internet Information Services (IIS).

  Darren

  
  Darren
  

• Rajesh Patavardhan

  SSCrazy

  Points: 2801

  More actions

  April 16, 2003 at 7:21 am

  #454347

  Do you mean using ASP code?.

  Use ADO to connect to database. Use ado connection object to connect to sql server using OLEDB connection string.

  Provide the server and database details in the connectionstring parameter.

  If this is what you are looking for and you need sample code then let me know.