技術(shù) 點
- 技術(shù)
- 點
- V幣
- 點
- 積分
- 71645
|
2#
發(fā)表于 2010-3-15 11:31:59
|
只看該作者
Function ADOSql(sql As String) As ADODB.Recordset
Dim Con As ADODB.Connection
Dim rs AS ADODB.Recordset
Set Con = New ADODB.Connection
Set rs = New ADODB.Recordset
With Con
.Provider = "SQLOLEDB"
.CommandTimeout = 5
.ConnectionTimeout = 10
.IsolationLevel = adXactCursorStability '設(shè)置隔離級別
End With
Con.Open "SERVER=192.168.1.200;Data=ERP;UID=sa;pwd="
rs.Open sql, Con, adOpenKeyset, adLockReadOnly
Set ADOSql = rs
End Function |
|