Dim cn As ADODB.Connection
Dim rs As ADODB.Recordset
Set cn = New ADODB.Connection
cn.Open "Provider=OraOLEDB.Oracle.1;Persist Security Info=False;Data Source=YOUR_DB", UserId,Pwd
strQuery = "select * from YOUR_TABLE"
Set rs = New ADODB.Recordset
rs.Open strQuery, cn, adOpenStatic, adLockOptimistic
Dim rs As ADODB.Recordset
Set cn = New ADODB.Connection
cn.Open "Provider=OraOLEDB.Oracle.1;Persist Security Info=False;Data Source=YOUR_DB", UserId,Pwd
strQuery = "select * from YOUR_TABLE"
Set rs = New ADODB.Recordset
rs.Open strQuery, cn, adOpenStatic, adLockOptimistic
1、实现共用通道,不用老建立connection
2、如果实在想手写代码也可以用它建立好联接,然后看它的属性,里面自动生成上面的连接语句
3、方便的进行交易保护操作!