ASP连接各类数据库的方式

ASP连接各类数据库的方式

Access

1. 
   
2. ConnStr = "Provider=Microsoft.JET.OLEDB.4.0;Data Source=" & Server.MapPath(Path) & ";Jet OLEDB:Database Password=" & Password & ";"
   

复制代码

Mssql

1. 
   
2. ConnStr = "Provider=Sqloledb;Data Source=" & DbIP & "," & DbPort & ";Initial Catalog=" & DbName & ";Persist Security Info=True;User ID=" & DbUid & ";Password=" & DbPwd & ";Connect Timeout=900;"
   

复制代码

Sqlite

1. 
   
2. ConnStr = "Driver={SQLite3 ODBC Driver};Database=" & Server.MapPath(Path) & ";"
   

复制代码

Mysql

1. 
   
2. ConnStr = "Driver={Mysql ODBC 5.3 Unicode Driver};Server=" & DbIP & ";Database=" & DbName & ";Uid=" & DbUid & ";Password=" & DbPwd & ";Port=" & DbPort & ";"
   

复制代码

这个真的有用，收藏了！

一往情僧 发表于 2024-11-14 08:02
这个真的有用，收藏了！

感谢支持啊