sql - 如何将 SQL 数据库连接到 Lotus Domino Designer？

Question

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

我是 Lotus Notes/Domino 的新手，我很想知道如何连接我的 SQL 数据库以在 domino 设计器中使用。谢谢。

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

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

Answer 1

这些问题被标记为 Lotusscript，所以我假设这是与 Lotusscript 相关的(而不是与 XPage 相关的)。

查看 Domino Designer 帮助数据库中的 ODBCConnection、ODBCQuery 和 ODBCResultSet Lotusscript 类。