Tuesday, September 10, 2002 06:06 AM
You will need a Notes server running to get the data. I really don't think you can get it out of there without a server running.
Then, I think also you will have to set up the Notes view of the data you are looking for so that it will support an odbc-type of query. I work with Notes all the time, but haven't done what you are wanting to do... I'd use more traditional methods. You can use Java to get to the Notes data, but I'd use the Notes native objects to get to it. There is a lot of very flexible stuff in there, but admittedly there is a learning curve too. Anyway, you can put the same code you would put in a Notes agent into a JSP or servlet, with some modifications. But the basic Domino object stuff is the same. And then you can do whatever you want with the data... port it to another system, print it to the browser... whatever.
There is something called NotesSQL that might be helpful for you if you really want to stick with SQL style queries. You can find it at:
You might have to register on the IBM site to download it, not sure. Also, there is a site for Notes developers here:
...all kinds of Notes related info here.