Thomas Kennedy 12.Mar.07 10:56 AM Lotus Notes LC LSX LC LSX - All Releases; LS:DO - All Releases AIX; Windows 2000
We have quite a few agents that use the LCLSX to connect to SQL Server. In many cases those agents use the same classes that we use on the client side. All our clients are on Windows, and almost all the RDBMS work we do is with SQL Server, so it's quite convenient to use the LCLSX with oledb from the client, but soon I will not be able to use it from the server (at least not with oledb).
What I would like to do is write a class that instantiates either the oledb library or the odbc library, depending on where the code is running. This class would therefor be a wrapper for LCConnection and LCFieldList - or - ODBCConnection and ODBCResultset, the decision being made at runtime.