This is from one of our classes that connects to lotus:
Class.forName ("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con = DriverManager.getConnection(URL, odbcProps);
Where odbcProps is a propert file with these entries:
DSN=MYODBCDSN
DATABASE=DBDIRECTORY\\DATABASENAME.NSF
SERVER=MYSERVERNAME
And URL is DSN preceded by "jdbc:odbc:"
As someone mentioned, you have to get the NotesSQL ODBC driver to make this
all work.
Also, since Lotus Notes doesn't allow you to specify a password for your
Notes ID, you will probably have to run this on a system with a Notes ID
that is not password protected.
Hope this helps.
----- Original Message -----
From: Pradeep Roy <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, August 02, 2000 12:56 AM
Subject: How Do I access data from LOTUS NOTES-5 database- in jsp or
otherwise....***Important*** please Help
> Hi All
>
> Could Anyone help me in getting data from Lotus Notes database. The first
> thing that I want to do is to connect to the database. and run a simple
> query. Please let me now the URL, Drivername, System name ( how to code
all
> this properly) etc. etc. that is required to get connected to Lotus Notes
> database specific...( preferbable with a partial code.)
>
> I have connected to Oracle & DB2/400 and using its data. Now I want the
> Lotus notes 5 data to be accessed which I don't know.
>
> Looking forward to your helps.
>
> Thanks & Regards
> Pradeep
>
>
===========================================================================
> To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff
JSP-INTEREST".
> Some relevant FAQs on JSP/Servlets can be found at:
>
> http://java.sun.com/products/jsp/faq.html
> http://www.esperanto.org.nz/jsp/jspfaq.html
> http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
> http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
>
===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
Some relevant FAQs on JSP/Servlets can be found at:
http://java.sun.com/products/jsp/faq.html
http://www.esperanto.org.nz/jsp/jspfaq.html
http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
