I have successfully managed to use the OLEDB feature of Lotus Notes LC LSX to retrieve data from a SQL2000 database. However I now have a requirement to run some stored procedures, some of which have input parameter sets, some no parameters. In each case there is no requirement for records to be retrieved.
I did write a script to run the SPs using ODBC, but most of my client PCs don't require ODBC, and there is no plan to install it.
After much Googling, I can't seem to find any useful information or example scripts. I located Sybase and DB2 examples and attempted to modify them for SQL to no avail. Does anyone have any experience with this to point me in the right direction?
Any help would be very much appreciated.
Thanks
Paul