Support - Knowledge base

Giving you the answers you need

Why not try our knowledge base for instant help and advice to enhance your online experience with Register365? From within the knowledge base you can browse our frequently asked questions and find the right answers to help solve your queries.

Home  >  Scripting  >  ASP (Active Server Pages)  >  View Article

How to make a connection to an MSSQL database from classic ASP.

1*1*1*1*1*

Article

DIM objConn 
Set objConn=Server.CreateObject("ADODB.Connection") 
objConn.ConnectionString="Provider=SQLOLEDB;Data Source=mssql.namesco.net;Initial Catalog=dbname;User Id=username;Password=password" 
objConn.Open

Replace dbname,username and password with the appropriate details for your database.

Rate This Article

How useful was this article?

Not useful A little useful Useful Very useful Everything I needed