Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
How can I access Lotus Domino/Notes database using ADO/VB6
- Thread starter dekra
- Start date
Guest_imported
New member
- Jan 1, 1970
- 0
Firstly, you can get an ODBC driver (notesSQL) but I would recommend that you do a better option<br><br>I wrote an application that connected and transferred data between Lotus Notes and Access by using the Lotus Notes Automation Classes. If you have Notes installed you should be able to pick it up in the Object Browser<br><br>In VB goto References and a list of DLL's will appear, make sure the LNAC is flagged and loaded.<br><br>It allows you to use Lotusscript in VB, and its quick, I cannot remember it too well cos it was a year ago. If you goto <A HREF=" TARGET="_new"> and search for Lotusscript you will see an outdated book about it. <br><br>Every notes item you declare as an object<br><br>eg: <br><br>Dim notesSession as object<br>Dim notesDatabase as object<br>set notesSession = CreateObject("Notes.NotesSession"
<br>set notesDatabase = notesSession.OPENDATABASE("{server},{database})<br><br>You will probably need a Lotusscript person to help you.<br><br>The create object method uses com and will search for the Notes.NotesSession class in the registry and create it if exists<br><br>Hope it helps
<br>set notesDatabase = notesSession.OPENDATABASE("{server},{database})<br><br>You will probably need a Lotusscript person to help you.<br><br>The create object method uses com and will search for the Notes.NotesSession class in the registry and create it if exists<br><br>Hope it helps- Status
