Public cnn As ADODB.Connection'打开数据库
Public Sub OpenDatabase()
On Error Resume Next
Err.Clear
Set cnn = New ADODB.Connection
Dim strcnn As String
With cnn
.Provider = "Microsoft.Jet.OLEDB.4.0"
.Properties("Data Source") = App.Path & "\data\aaaa.mdb"
.Properties("Jet OLEDB:Database Password") = "bbbbbb"
.Open
End With
If Err.Number <> 0 Then
MsgBox ("不能打开数据库,请确定数据库文件是否存在!"), 48, "数据库连接错误" '打开失败
End
End IfEnd Sub
'打开表PP
Dim rsPP As ADODB.Recordset
Dim strSQLpp As String strSQLpp = "select * from PP"
Set rsPP = New ADODB.Recordset
With rsPP
Set .ActiveConnection = cnn
.LockType = adLockOptimistic
.CursorType = adOpenKeyset
.Open strSQLpp
End With
Public Sub OpenDatabase()
On Error Resume Next
Err.Clear
Set cnn = New ADODB.Connection
Dim strcnn As String
With cnn
.Provider = "Microsoft.Jet.OLEDB.4.0"
.Properties("Data Source") = App.Path & "\data\aaaa.mdb"
.Properties("Jet OLEDB:Database Password") = "bbbbbb"
.Open
End With
If Err.Number <> 0 Then
MsgBox ("不能打开数据库,请确定数据库文件是否存在!"), 48, "数据库连接错误" '打开失败
End
End IfEnd Sub
'打开表PP
Dim rsPP As ADODB.Recordset
Dim strSQLpp As String strSQLpp = "select * from PP"
Set rsPP = New ADODB.Recordset
With rsPP
Set .ActiveConnection = cnn
.LockType = adLockOptimistic
.CursorType = adOpenKeyset
.Open strSQLpp
End With
如:conn.open "dsn=...;uid=...pwd=..."
但是如果你用OLEDB或者ODBC Driver的方式的话,就不需要
如conn.open "provider=msdaora;uid=...;pwd=..."
conn.open "driver={microsoft ODBC for Oracle";uid=...;pwd=..."
这个问题我想你只要看看书,或在论坛里搜索一下,应该很容易解决。
conn.open "driver={microsoft ODBC for Oracle";uid=...;pwd=..."
就可以了
================================================================CSDN 论坛助手 Ver 1.0 B0402提供下载。 改进了很多,功能完备!★ 浏览帖子速度极快![建议系统使用ie5.5以上]。 ★ 多种帖子实现界面。
★ 保存帖子到本地[html格式]★ 监视您关注帖子的回复更新。
★ 可以直接发贴、回复帖子★ 采用XML接口,可以一次性显示4页帖子,同时支持自定义每次显示帖子数量。可以浏览历史记录!
★ 支持在线检测程序升级情况,可及时获得程序更新的信息。★★ 签名 ●
可以在您的每个帖子的后面自动加上一个自己设计的签名哟。Http://www.ChinaOK.net/csdn/csdn.zip
Http://www.ChinaOK.net/csdn/csdn.rar
Http://www.ChinaOK.net/csdn/csdn.exe [自解压]
MousePointer = vbHourglass ' Open the recordset
With rs
' Set the properties & open
.Source = "select * from authors"
.ActiveConnection = cn
.CursorType = adOpenKeyset
.LockType = adLockOptimistic
.Open
End With ' Populate the grid
Set hflxResults.DataSource = rs
MousePointer = vbDefaultEnd Sub
朋友在吗?按照你的说法可以了,不过有一点小问,在创建记录集时'打开表PP
Dim rsPP As ADODB.Recordset
Dim strSQLpp As String strSQLpp = "select * from PP"
Set rsPP = New ADODB.Recordset
With rsPP
Set .ActiveConnection = cnn
.LockType = adLockOptimistic
.CursorType = adOpenKeyset
.Open strSQLpp
End With
在with rspp 处
set 可以省略的
不过还是感谢你,呆会给分