用ado实现调用sql server数据库怎么用呀
我想用ado实现调用 sql server数据库以实现远程调用怎么用
[解决办法]
dim conn as new adodb.connection
with conn
If .State = adStateOpen Then .Close
.ConnectionString = "driver=SQL Server;server=计算机名或IP地址;uid=sa;pwd=sa的密码;database=数据库名称 "
.CommandTimeout = 300
.Open
end with
[解决办法]
ConnectionString = "Provider=SQLOLEDB.1;Persist Security Info=True;User ID= " & _
UserID & ";Initial Catalog= " & Database & ";Data Source= " & _
Server & ";Password= " & Password & "; "
cn.Open ConnectionString
strSQL= "Select * from TableName "
rs.Open strSQL, cn, adOpenDynamic, adLockOptimistic
'////谢谢这样可以实现调用别的机器的数据库了吧?
'把Server改为其他电脑名称或IP地址
[解决办法]
ConnectionString = "Provider=SQLOLEDB.1;Persist Security Info=True;User ID= " & _
UserID & ";Initial Catalog= " & Database & ";Data Source= " & _
Server & ";Password= " & Password & "; "
cn.Open ConnectionString
strSQL= "Select * from TableName "
rs.Open strSQL, cn, adOpenDynamic, adLockOptimistic
[解决办法]
请问如果使用ADO控件去连接,应该怎么操作啊???
