VC连接数据库

来源:互联网 发布:宇宙少女知乎 编辑:程序博客网 时间:2024/04/29 22:31

SQL Server连接字符串:
"User ID=登陆名;Data Source=数据源;Password=密码;Initial Catalog=数据库名;Provider=SQLOLEDB.1;Persist Security Info=True";


Oracal连接字符串(微软格式):
"Provider=MSDAORA;Data Source=MyOracleDB;User Id=myUsername;Password=myPassword;";

//Oracle标准安全级别
"Provider=oraoledb.oracle;Data Source=MyOracleDB;User ID=myUsername;Password=myPassword;"

 

//access连接字符串
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=db.mdb;Mode=Share Deny None;User ID=Admin;Jet OLEDB:Database Password=;";