|
|
Please forget ODBC (each time it's possible...)
Thierry Cayla
How many times I see posts in the Lotus DD forums from developers struggling with ODBC connections, system data sources on the Domino server, and all that painful stuff.
Connections to relational databases like Oracle or MS SQL Server can be set up much more easily with a few lines of LotusScript using a technique called ADO (ActiveX Data Objects).
This is made possible since the corresponding connection layer is included in every Microsoft OS since Windows 2000 (and especially on Windows 2003 server, for server-side connections).
This technique has several advantages apart the simplicity, among them the fact that it outperforms ODBC from far, that it uses the same object model to handle different back-end databases, and by the way that it does not need the dotNet framework to function.
As an example, here is how to retrieve data from a PeopleSoft HRMS system lying on an Oracle 10g database.
---------------------
http://dominoeffects.serveblog.net/dfxblog.nsf/d6plinks/TCAA-7YAH3U
Nov 30, 2009
14 hits
| Recent Blog Posts |
Sorry, no records were found!
|
