Access2013 Mssql2012 数据库连接字符串

最新推荐文章于 2023-08-26 09:41:19 发布

weixin_33985507

最新推荐文章于 2023-08-26 09:41:19 发布

阅读量131

点赞数

文章标签：数据库

直接在调用的地方设置

// access 2003

DBConStr = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" + AppPath + "sample.mdb";
// access 2007
DBConStr = "Provider=Microsoft.ACE.OLEDB.12.0; Data Source=" + AppDomain.CurrentDomain.BaseDirectory + "Sample.accdb";
Driver ={ Microsoft Access Driver(*.mdb, *.accdb)}; DBQ = path to mdb/ accdb file”
// mssql 
DBConStr = "Provider = SQLOLEDB.1;Data Source = 192.168.3.251;Initial Catalog = Sample;User ID = sa; Password = 1";