ADO.NET & LotusScript

HCL Domino Domino Forum
1

I’m currently using LS:DO objects to pump Notes data into SQLServer. I’m not using the AddRow or SetValue methods; instead, I’m constructing SQL statements and executing them directly. This works fine, but it seems that the LS:DO objects leak memory. Is it possible to use ADO.NET objects in LS to accomplish the same task? I need to push the data from Notes to SQLServer, rather than pull the Notes datafrom a .NET app. Any suggestions, sample code?

2

Subject: ADO.NET & LotusScript

No, ADO.NET interfaces are not COM compatible and therefore not accessible form LotusScript. You have at least four choices.

  1. Write a .NET wrapper class that has COM friendly interfaces that you can call from LotusScript, passing you data.

  2. Write a .NET routine to pull data from Notes, probably using a tool such as Proposion N2N (Products A-Z).

  3. A combination of 1 + 2. (Write a routine that pulls Notes data, but call it from LotusScript.)

  4. Forget .NET and use classic ADO to write to SQL server.