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

del.icio.us:Connection to access or MS SQL database in ASP digg:Connection to access or MS SQL database in ASP spurl:Connection to access or MS SQL database in ASP furl:Connection to access or MS SQL database in ASP reddit:Connection to access or MS SQL database in ASP fark:Connection to access or MS SQL database in ASP Y!:Connection to access or MS SQL database in ASP

Related Posts