Question

VBA连接oracle数据库问题

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

分不要浪费了，给你吧

Answer 1

将Stmt=set names GBK修改为：
SET NAMES 'GBK'