WINDOWS窗体要怎么调用别的机子上的数据库
WINDOWS窗体要怎么调用别的机子上的数据库,代码共享下!
1. access
oConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\\ServerName\DatabaseFolder\Database.mdb;Jet OLEDB:Database Password=databasepw;Persist Security Info=False"
2. sql server
ConnStr = "Provider=SQLOLEDB.1;Network Library=DBMSSOCN;Persist Security Info=True;User ID=UserName;Password=Password;
Initial Catalog=远程数据库名;Data Source=203.129.92.1"