Hi,
I have a lotus note database that exports data to an excel spreadsheet which I save on to my desktop. I have a user who wants this excel report ftped to their SQL/DB2 server. Is it possible for my lotus application to connect to their server? or have data from my application sent to their server?
Thanks in advance for your input!
Subject: Connect to SQL/DB2
Yes you can set up notes to FTP.
I’ve used this class and also called the ftp process via the shell.
Subject: Connect to SQL/DB2
It’s also worth checking that Notes → Excel → ftp → SQL/DB2 is the most appropriate way to transfer this data. How about an XML export? Or connecting to a web service? If this is a regular transfer, then it would probably be worth looking at one of these more robust mechanisms.
Rupert Clayton
Chicago
Subject: RE: Connect to SQL/DB2
Thank you both for your input.