Solved

Connecting to Domino

Posted on 2010-11-17
13
507 Views
Last Modified: 2013-11-16
I have a client that uses Domino/Notes for scheduling work in their shop. They want to me to call a Notes process and pass some data whenever my system is updated. The source of the data is a SQL database. My plan was to use a VB script or a .Net program to look for new data in the SQL table and then pass it to Notes.

I've tried to login using a VBScript to Domino and I can only do it when I have a Domino client running. I cannot pass the user ID and password for some reason.

Here's what I have:

 
Dim session 
Set session = CreateObject("Lotus.NotesSession") 
Call session.Initialize("password")

Open in new window


I get an error telling me the server cannot be opened.
0
Comment
Question by:jczander
  • 4
  • 3
  • 3
  • +1
13 Comments
 
LVL 22

Expert Comment

by:mbonaci
ID: 34162213
Which version of Domino?
If it's 7 or above, I suggest you create a web service, provided by Domino server and simply call it from SQL SP.

What is the exact error message?
0
 
LVL 22

Expert Comment

by:mbonaci
ID: 34162220
Here's Designer help link about Initializing a Notes Session:

http://publib.boulder.ibm.com/infocenter/domhelp/v8r0/topic/com.ibm.designer.domino.main.doc/H_ACCESSING_THE_DOMINO_OBJECTS_THROUGH_COM_INITIALIZING.html

Be sure to follow the link "Accessing the Domino Objects through COM", located at the bottom of the page.
0
 
LVL 46

Accepted Solution

by:
Sjef Bosman earned 500 total points
ID: 34162653
Ask them if you can send the application a mail, with the data to be passed (in XML format for example). Much cleaner, no sessions, no password hassle, no direct connections...
0
Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
LVL 22

Expert Comment

by:Bill-Hanson
ID: 34163873
There is nothing wrong with your code above.  My guess is that you installed the Notes Client, but never ran it.  You have to run the client once to complete setup.  Then try your code again.

Also, I have not been able to get the COM library to work under 64 bit using VB Script.  It works for VBA, ,C# and VB.Net under 64 bit, and it works for VB Script under 32 bit, but not VB Script under 64 bit.  Not sure why.  I use C# for most Domino integration projects.
0
 

Author Comment

by:jczander
ID: 34176019
They are on version 8.x

I have run the client many times.

Domino is running on a 64 bit box, but the client is 32 bit.

The weird thing is it runs from a command line if I have a client open and the user ID on the script matches the user ID of the client.
0
 
LVL 22

Expert Comment

by:Bill-Hanson
ID: 34176398
For NotesSession.Initialize, the client must be installed and only the current user has access.  If the client is not running, it will launch automatically.  If you pass an empty string to NotesSession.Initialize, the user will be prompted to authenticate automatically.

If you are running the script on the same machine as the Domino server, then you can use the NotesSession.InitializeUsingNotesUserName method which allows you to authenticate as any trusted user.

Personally, I would setup a Domino web service as mbonaci suggested, and consume it in a .Net app.  Much more elegant than COM.
0
 
LVL 46

Expert Comment

by:Sjef Bosman
ID: 34179639
@Bill: and how about my mail idea?
0
 
LVL 22

Expert Comment

by:Bill-Hanson
ID: 34187779
It would depend on the application and how 'real-time' the data access needs to be.  I tend to use email as a last resort when designing a new integration points, but it certainly works.
0
 
LVL 46

Expert Comment

by:Sjef Bosman
ID: 34193084
In disparate systems like the ones mentioned above, mail would my preferred data communication vehicle... Technically speaking, only to be abandoned when the data is to be made available on the other side 'real-time'.

@jczander: can you give us some figures about the application, i.e. how often has data to be exchanged, and how much?
0
 
LVL 22

Expert Comment

by:mbonaci
ID: 34194637
Generally speaking (not-only-domino-related), web services are introduced exactly for communication between loosely coupled systems.
Add ESB (see EDA architecture) and they are not coupled at all, and IMHO, that should be the ultimate (one step beyond SOA) goal for every enterprise architecture.

I mean, you cannot even begin to compare mail with that.
0
 
LVL 46

Expert Comment

by:Sjef Bosman
ID: 34194789
Touché...
0
 

Author Comment

by:jczander
ID: 34252800
Thanks all for the help. I eventually settled on the mail approach. I'm writing out a VBScript that sends an e-mail with the data in the body. It is less that ideal, but it works as close to real time as I can get.

As a relational database and .Net guy, I'm not a big fan of Notes.

Thanks again.
0
 

Author Closing Comment

by:jczander
ID: 34252817
general answer, but led me in the right direction.
0

Featured Post

Networking for the Cloud Era

Join Microsoft and Riverbed for a discussion and demonstration of enhancements to SteelConnect:
-One-click orchestration and cloud connectivity in Azure environments
-Tight integration of SD-WAN and WAN optimization capabilities
-Scalability and resiliency equal to a data center

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Encrypted Mail message in a NSF 10 30
Domino not switching to TLS 1.0 4 802
Lotus Domino 9.0 install on same pc with 8.5.3 9 134
Bulk lotus notes account creation 3 89
For users on the Lotus Notes 8 Standard client, this article provides information on checking the Java Heap size and adjusting it to half of your system RAM in attempt to get the Lotus Notes 8.x Standard client to run faster.  I've had to exercise t…
I thought it will be a good idea to make a post as it will help in case someone else faces these issues. I trust this gives an idea how each entry in Notes.ini can mean a lot for the Domino Server to be functioning properly. This article discusses t…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

830 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question