Thomas Kennedy 12.Mar.07 10:56 AM Lotus Notes LC LSXLC LSX - All Releases; LS:DO - All ReleasesAIX; 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.