vba - 通过 VBA 连接到 Vertica

Question

我正在尝试通过 VBA 代码连接到 Vertica。但我面临这个错误：

 Run Time Error '-2147467259 (80004005)':
 Automation error
 Unspecified error

我究竟做错了什么？

Dim cn As ADODB.Connection
Set cn = New ADODB.Connection
Dim rs As ADODB.Recordset

Dim strConn As String
strConn = "Driver={Vertica}; Servername=localhost; 
Database=jdbc:vertica://JSVERTICA:5433/PVXDW; Username=admin; Password=pass"

cn.Open strConn
cn.Close
Set cn = Nothing
MsgBox "Connected"

标签： vbavertica