VBA利用PLSQL developer(版本为7.15)如何与oracle数据库连接;Db为数据库,user为登录帐号,pwd为密码
"DRIVER={SQLOLEDB.1};Database=" & Db & ";Uid=" & user & ";Pwd=" & pwd & ";Stmt=set names GBK"请给修改下
问题已解决
Sub connect_数据库()
Dim strconnt As String
strconnt = ""
Set connt = New ADODB.Connection
Dim rs As Object
Set rs = New ADODB.Recordset
Dim sevip, Db, user, pwd As String
'设服务器地址、所连数据,及登录用户密码
strconnt = "DRIVER={Microsoft ODBC for Oracle};Password=*;User ID=**;Data Source=***" '
connt.ConnectionString = strconnt
connt.Open
End Sub
分不要浪费了,给你吧