ASP连接各类数据库的方式 连接Access: ConnStr = "Provider=Microsoft.JET.OLEDB.4.0;Data Source=" & Server.MapPath(Path) & ";Jet OLEDB:Database Password=" & Password & ";" 连接Mssql: ConnStr = "Provider=Sqloledb;Data Source=" & DbIP & "," & DbPort & ";Initial Catalog=" & DbName & ";Persist Security Info=True;User ID=" & DbUid & ";Password=" & DbPwd & ";Connect Timeout=900;" 连接Sqlite: ConnStr = "Driver={SQLite3 ODBC Driver};Database=" & Server.MapPath(Path) & ";" 连接Mysql: ConnStr = "Driver={Mysql ODBC 5.3 Unicode Driver};Server=" & DbIP & ";Database=" & DbName & ";Uid=" & DbUid & ";Password=" & DbPwd & ";Port=" & DbPort & ";" |