aRo` automating your e-commerce

Connection to access or MS SQL database in ASP

The best way of connecting to a database is including a separated file with the database info. Afterwards u can always check if the database connection state is open.

MS SQL
set cnn = Server.CreateObject(“ADODB.Connection”)
cnn.ConnectionString = “Provider=SQLOLEDB.1;User ID=User;Passwd=;Initial Catalog=ASPDB;Data Source=server”
cnn.Open

Microsoft Access
set cnn = Server.CreateObject(“ADODB.Connection”)
cnn.Provider = “Microsoft.Jet.OLEDB.4.0″
cnn.ConnectionString = Server.MapPath (“/mywwwfolder”) & “\database.mdb”
cnn.Open

check connection state
if cnn.State = 0 then
cnn.Open
end if

Popularity: 3% [?]