////Ado
Dim StrCon As String
StrCon = "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;" _
& "Initial Catalog=你的数据库名称;Data Source=" & 你的IP地址 & ";" _
& "Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;" _
& "Use Encryption for Data=False;Tag with column collation when possible=False"
dim AcSys as new adodb.connection
With AcSys
If .State = adStateOpen Then .Close
.ConnectionString = StrCon
.ConnectionTimeout = 30
.Open
End With
///////
Dim StrCon As String
StrCon = "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;" _
& "Initial Catalog=你的数据库名称;Data Source=" & 你的IP地址 & ";" _
& "Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;" _
& "Use Encryption for Data=False;Tag with column collation when possible=False"
dim AcSys as new adodb.connection
With AcSys
If .State = adStateOpen Then .Close
.ConnectionString = StrCon
.ConnectionTimeout = 30
.Open
End With
///////
解决方案 »
- a Transact-SQL function 和存储过程有什么区别
- 错语20565, 数据库还不支持全文.
- 菜鸟提问!! 如何能个得到上个月的第一天和最后一天的日期,比如说:今天是2006-3-1,我想得到2006-2-1 00:00:000和2006-2-28 23:59:000
- 在sql server 2000中向一个表中插入数据时,日志在不断增长,数据还没有插入完,日志空间就把磁盘占满了,怎么办?求教大家.
- 求一个视图语句补全
- 数据库同步问题 SQL Server和PDA
- 一个关于数据库权限的问题!
- "表B中的列与现存的主键或UNIQUE约束不匹配"---急!!我表姐问!在线等!
- 求一SQL 指令(主表金额比例分配问题)
- SQL 查询优化.....
- 这个SQL语句如何写?求教!
- 两张结构相同的表的合并查询?
strSQL="EXEC [SP] @CODE_IN = 'BATCHEXCHANGE' "
With qdserver
.Connect="odbc;driver={SQL Server};database=datqbase;server=servername;pwd=123 "
.ReturnsRecords=True
.SQL = strSQL
Set rsBatch=.OpenRecordset(dbOpenSnapshot,dbSQLPassThrough)
End With
dim ar_tmp as new adodb.recordset
with ac_tmp
...
...
end withtxtSQL = "select 名称 from 学生表 where 号码='"& combobox.text &"'"
with ar_tmp
if .state=adstateopen then .close
.open txtSQL,ac_tmp,adopenkeyset,adlockreadonly
end withif ar_tmp.recordcount>0 then
text.text=ar_tmp!名称
else
text.text=""
endif