ACCESS數(shù)據(jù)庫接接代碼:
dim db,Conn,ConnStr
db="您的ACCESS數(shù)據(jù)庫路徑" set conn=Server.CreateObject("ADODB.Connection") ConnStr = "Provider = Microsoft.Jet.OLEDB.4.0;Data Source = " & Server.MapPath(db) conn.open ConnStr
MS SQL Server數(shù)據(jù)庫接接代碼:
dim SqlDatabaseName,SqlPassword,SqlUsername,SqlLocalName,Conn,ConnStr
SqlDatabaseName="SQL數(shù)據(jù)庫名稱" SqlPassword="SQL數(shù)據(jù)庫登密碼" SqlUsername="SQL數(shù)據(jù)庫登陸用戶名" SqlLocalName="SQL服務(wù)器IP地址"
set conn=Server.CreateObject("ADODB.Connection") ConnStr = "Provider = Sqloledb; User ID = " & SqlUsername & "; Password = " & SqlPassword & "; Initial Catalog = " & SqlDatabaseName & "; Data Source = " & SqlLocalName & ";" conn.open ConnStr |