Set conn = server.createObject ("adodb.connection") connStr = "provider = oraoledb.racle.1; persist security info = true; user ID = bai; password = bai; data source = dates" conn.open connStr
strsqlservername = "(local)" "server name or address strsqldbusername =" sa "" database account strsqldbpassword = "baijunyi" "database password strsqldbname =" main "database name ---------------------------------- -------------------------------------------------- -------------------------------
SQL Server OLE DriverSet conn = Server.CreateObject ( "ADODB.Connection") strCon = "Provider = SQLOLEDB.1; Persist Security Info = False; Server =" & strSQLServerName & "; User ID =" & strSQLDBUserName & "; Password = "& strsqldbpassword &"; database = "& strsqldbname"; "
Conn.open strcon
