java访问domino数据库_如何将SQL数据库连接到Lotus Domino Designer？

我正在创建一个必须具有动态组合框的Lotus Notes应用程序 . 需要通过从SQL数据库中进行选择来检索组合框的选项 .

我是Lotus Notes / Domino的新手，我很想知道如何连接我的SQL数据库以便在多米诺骨牌设计器中使用 . 谢谢 .

编辑：这是客户端，而不是网络

Sub Initialize

On Error GoTo e

Dim pw As String,user As String,odbc As String

Dim i As Integer

Dim conn As ODBCConnection,query As ODBCQuery,rs As ODBCResultSet

Dim db As NotesDatabase

Dim session As NotesSession

Dim view As NotesView

Dim doc As NotesDocument

Dim newDoc As NotesDocument

Set session = New NotesSession

Set db = session.CurrentDatabase

Set view = db.GetView("Reports")

Set doc = view.GetFirstDocument

Set conn = New ODBCConnection

Set query = New ODBCQuery

Set rs = New ODBCResultSet

Set query.Connection = conn

Set rs.Query = query

odbc = "server"

user = "user"

pw = "pass"

Call conn.ConnectTo( odbc , user , pw )

i = 0

query.SQL = "SELECT * FROM table"

rs.Execute

rs.FirstRow

Do While Not rs.IsEndOfData

i = i + 1

rs.NextRow

Loop

conn.Disconnect

Exit Sub

e :

MessageBox "Error " & Err & " line " & Erl & ": " & _

Error

Exit Sub

End Sub