ODBC Data in a NotesView

HCL Domino Domino Forum
1

Currently I’m trying to retrieve data from a MS Access database and to show them in a NotesView. When I use a @dbcommand ODBC connection to populate a listbox on a custom notesform its successfully retrieving data from that database.

Now I want to show this data in a notesView. I have tried several things such as specifying the @dbcommand in the selection query of the view, add a @dbcolummn entry in the columns I’ve specified in the view but until now I dont get any results in my notesview.

Can someone tell me how I can accomplish this task?

2

Subject: Need another approach

A notes view can only display Notes documents. So, to show data from your Access database, you will have to store it in a set of Notes documents.

There are many ways to approach this. Take a look at DECS - a way of interfacing between Notes and external databases that does not require programming. It has some limitations, but it may meet your needs.

If your needs are more complex, you will need either LEI (an add-on product) or coding using lsxlc tools.

hth