It is possible that other version of the ODBC file installer are needed for different Notes versions. Any further idea you think I shall check? All the steps below are to be performed on the machine where the Database server is running. Dear admin, This works very fine but I have a little problem in my case. My strongly recommended books to read. The parameter MaxVarcharLen is optional because my fields of table in Domino have length longer than bytes default value , I have to set this value so that I can read all content out.
|Date Added:||13 October 2010|
|File Size:||29.4 Mb|
|Operating Systems:||Windows NT/2000/XP/2003/2003/7/8/10 MacOS 10/X|
|Price:||Free* [*Free Regsitration Required]|
Your email address will not be published.
C# – Lotus NotesSQL Driver install, configure and connect to server through ODBC
The code above just demonstrates how we can build a connection to Domino server and read data out such as which tables and views are available in database. Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type. This method requires Lotus Notes client must be installed at same computer and an authorization is also required. I solved my odbc driver problem using your path variables advise.
Notes/Domino 6 and 7 Forum : NotesSQL j ODBC error when adding DSN
You may have to login and accept the legal agreement again. For user name option, you can use your user. We use Lotus Notes version 8. Since there isn’t a 64 bit Notes client available we have tried installing the 64 bit Domino server. Disable the Lotus Domino services to make sure they don’t start when you restart the machine.
What should I do? I’ve researched a number of instructions available on the web and I’ve tested the steps to created a linked server but none of tutorials we I found seemed explain well enough what you need to do. Yes there is another way to get data from Lotus Notes. You can use the defaults forr everything. What a hard work! You’ll have to login with an IBM login. However when attempting notedsql bring the connection in Alteryx, upon selecting the connection, i get the blue spinning symbol on mouse pointer a couple of times, then nothing.
If there is anyone out there who has set this up would appreciate any insight. What i now get is just a table list, but no visible schema.
Thank you very, very much. Your post is very useful. It is not available on the regular NotesSQL page.
Path seeting reboot doesn’t seem to be required, Windows 7 64bit Enterprise Add this tye path variable or equivalent for your machine My strongly recommended books to read. I tried on https: Maybe try you with a fresh installation of test machine and check if it works.