您的位置:首页 > 博客中心 > 数据库 >

Access2013 Mssql2012 数据库连接字符串

时间:2022-03-14 04:12

 

 

直接在调用的地方设置

 

// 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";

 

热门排行

今日推荐

热门手游