＋设为首页 ＋添加到收藏夹
如何连接？用什么驱动？
急求答案
set Cnn as new adodb.connection
cnn.open "provider=sqloledb;driver=sql server;server=ServerName;database=DatabaseName;user id=sa;password=密码;connection timeout=60"
就可以连接了之后，就可以
set CnnS as new adodb.recordset
cnns.open "select * from 表名",cnn
操作各种表了。
Dim CN As New ADODB.Connection 定义数据库的连接存放数据和代码
Dim Rs As New ADODB.Recordset
CN.ConnectionString = "Provider=sqloledb;Data Source=pmserver;Initial Catalog=northwind;User Id=sa;Password=sa;"
CN.Open
Rs.CursorLocation = adUseClient
Rs.Open "select * from employees", CN, adOpenDynamic, adLockBatchOptimistic
Set DataGrid1.DataSource = Rs
