The Dblookup is not working in v6.5. When I am writing a Dblookup formula to connect to an access database I am getting the error “Data access application layer. Could not execute @Db function.”
I have already defined a data connection in the Lotus Notes database.
Subject: RE: DbLookup Not Working
@DbLookup works just fine in Notes 6.5. You have some setup problem on your system – ODBC is not configured correctly for access to the database, probably. Perhaps you have some confusion regarding where the code executes. If the formula is evaluated by the Notes client, then the Notes client has to be configured to access the database. This is true even if the Notes application is on a server.