I am trying to configure NotesSQL (version 8) so that I will be able to insert documents into a Domino database from a .NET web service.
I am a developer who is relatively unexperienced with domino development, and I haven’t a clue how the admin part of Notes works, as far as security and such.
I have a few questions.
Since Notes cannot be installed on the same servers as our application, I am curious if it would be possible to install NotesSQL on the Domino server and run the .NET web service on that same machine. If so, can someone point me to some clear instructions as to how to configure this? As soon as I started reading about setting up special ini and id files for this I got lost! Should the ini and id files used be sitting on that same machine? How do I go about setting up special ini and id files for the web service to use?
Temporarily, I have configured NotesSQL to use my own ini and id files on my machine, and I am able to set up an ODBC connection using this setup. However, when I attempt to connect to the database through the ODBC data source from my .NET application I receive the following error:
“The driver doesn’t support the version of ODBC behavior that the application requested”
I thought that this error typically indicated that the version of NotesSQL did not support connections coming from .NET, but we have version 8.
Install NotesSQL(and all other softwares needed by NotesSQL, as per product documentation. This might include Lotus Notes client ) and .Net Web Service server on a second machine.
Ensure that these two machines are on same network, no firewall between them.
Now, open Lotus Notes client on Machine# 2. Check connectivity to Domino server on Machine# 1. To have this connectivity, Lotus Notes client will ask for an ID file. Once logged in with ID file, the ini file on machine# 2 will be updated with path of ID file you have used.
On machine# 2 configure ODBC and related stuff.
So the connection goes like this:
.Net code on machine# 2 → ODBC connection on machine# 2 → Notes SQL on machine# 2 → Domino server on machine# 1.
To create new user ID on Domino server, you need to have following:
Lotus Administration client
A user id with administrative privileges
Know the path of certifier id file domino server, and the password for certifier id
If you have all these, a new user could be registered fairly straight forward by opening Notes Administration client with administrator id. Go to People Tab → register new user. This will create a new id file for new user. Get a copy of this id file and put it on machine# 2.