Connect to Mssql example needed - Webmaster Forums - Webmaster forum for HTML, PHP, ASP, CSS and more

proctor · 10-22-2005, 03:54 PM

Hello all,

My host allows me a database. I need an example code of how to connect to the Mssql database or what is the best way to do so. Thanks.

econ · 10-24-2005, 08:24 PM

This may help you get started.

Code:

Dim Conn, RS, sql
  Set Conn = Server.CreateObject("ADODB.Connection")
  Conn.Open "Provider=SQLOLEDB;Data Source=(local);Database=db_name;UID=user_name;PWD=user_pass"
  Set RS = Server.CreateObject("ADODB.Recordset")
  RS.Open sql, Conn, 1, 1

http://www.asp101.com/articles/john/...ng/default.asp
cheers