This part 1 of 3 in the article series “Classic Notes: How to communicate with IBM Connections from LotusScript wrapping IBM SBT with LS2J”.
Read the others here:
… embark! …
- Ooops, but I am mostly doing LotusScript, you say … what now?
Perhaps you ask a question on StackOverflow to see if anybody has some advice for your scenario (just completely out of the sky – perhaps something similar to this question ). The chances are that you’d get a lot of advice abandoning your old and tired LotusScript in favor for the much more modern Java language. Your challenge is that you have a lot of LotusScript code that you would love to enhance with the new cool IBM SBT possibilities, and perhaps not the time to take the heavy plunge into learning a new language.
This article – which assumes a whole bunch of details are in place – will show you how to have this small piece of LotusScript code …
… put an entry into an Activity Stream in a specified community like this;
If you have seen error messages like “30061 - Error: Relational database BLABLA not found., Connector 'db2', Method -Connect- (-30061) - Relational database BLABLA not found.” or “Error: Communication error occurred on distributed database processing. See SQ30080 for invalid possibilities. A common error is that the password is case sensitive and is not being provided in the correct case” you’re not alone!
Read on how to see the bigger picture on how IBM i’s “Relational Database Directory Entries” should be configured based on what you see in the real target database. Finally you’ll see how to code Lotus Connectors LSX (LCLSX) to use this information to connect to the database.
Most of our Domino servers run on IBM i (aka System i, iSeries and AS/400). Since IBM i have DB2 natively supported, there is no need to install DB2 Client or DB2 Data Server Drivers (more on those below). The target DB/2 server is running on a remote Windows server, and I thought it would be a breeze to connect IBM i and the Windows machine together. Not so! First and foremost, there is sparse information on the net on how to exactly do this. You very quickly find sample code similar to this;
So how come the code above bails out at the Connect-method?
Ever wanted to launch a database directly in Designer? Yes, then you probably are a developer
Read more to see a snippet of LotusScript code on how to launch the Designer with a specified database.
BTW – wish I could specify a specific designer element, so if you know, please chime in.
Have you ever wanted to access the Search Bar from LotusScript?
Being able to do so would perhaps remove the need for various homecooked solutions on how to do full text searches and display the results to the user. Even though we do have programmatic access to full text, I have allways felt that something is missing. Why not just use the standard search bar in the Notes client? This post describes how to do exactly that with a couple LotusScript classes, using Windows API functions. You can set and get the text of the Search Bar, and even click the "Search" button programmatically.
Last year the official session schedule contained several presentations for download even before Lotusphere. This year I haven’t seen them yet.
Update 24.JAN.2012: See comment from Brian below on how to fix this issue
The server has been upgraded to Domino 8.5.3 and now my iPhone nor iPad can’t open the mails without getting an error. I can can log in, and see the Inbox fine. All new mails are present, but as soon as I click on a message to open it, I get an error message (“Cannot open page, the URL cannot be shown”. The exact Norwegian error message is “Kan ikke åpne side, Safari kan ikke åpne siden, Feilen var: “URL-en kan ikke vises”). Has anybody seen this?