Connecting Lotus notes from SQL Server

Asked By Raghavendra Selvan
09-Feb-10 10:04 AM
Earn up to 0 extra points for answering this tough question.

Hi,

One of my task is I need to connect to Lotus Notes Database from the SQL Server 2000 . In my Lotus Notes database I have set of flat files . I need to connect to the Lotus Notes and take the file and move to the SQL server one particular server folder  . I found a link in Internet but that did not help me . Could you help me as how to connect to Lotus Notes database from SQL server .

I have written a SQL code to read the flat file and move it to the table in SQL server . Any Suggestion or ideas are really a welcome move  for me .

This is the Link I found in Internet , but it did not help me . Because my boss told me installing the Lotus notes & drivers in sql server will be difficult . So I need any other options for the same .

http://www.databasejournal.com/features/mssql/article.php/3462011/Connect-to-Lotus-Domino-using-SQL-Server-Linked-Server.htm

Thanks
Raghav

  re: Connecting Lotus notes from SQL Server

Web Star replied to Raghavendra Selvan
09-Feb-10 12:40 PM
U can connect using ODBC deriver .

A Lotus Notes database can be connected to an application using an ODBC object with the help of the NotesSQL utility. This tutorial will show you how to set it up.
http://www.easysoft.com/applications/lotus_notes_domino/odbc.html
http://articles.techrepublic.com.com/5100-10878_11-5116212.html

  re: Connecting Lotus notes from SQL Server

Kim van den Berg replied to Raghavendra Selvan
21-Jun-10 09:29 AM

Hi Raghav,

We have a Notes to SQL solution available on our website (a server based system, not just a driver). The solution is not for free, but the user manuals are, maybe they are usefull to you.

 

greetings,

Kim

  re: Connecting Lotus notes from SQL Server

Kim van den Berg replied to Raghavendra Selvan
21-Jun-10 09:30 AM

Hi Raghav,

We have a Notes to SQL solution available on our website (a server based system, not just a driver). The solution is not for free, but the user manuals are, maybe they are usefull to you.

 

Link:

http://www.lialis.com/Applications/EnglishSite.nsf/dx/Notes_to_SQL

 

greetings,

Kim

  re: Connecting Lotus notes from SQL Server
Kim van den Berg replied to Kim van den Berg
06-Dec-10 08:43 AM
The URL I posted is outdated, hereby the new URL for the Convert Notes data to SQL solution: http://www.lialis.com/lotussolutionprovider.nsf/pages/convertnotesdatatosql
Create New Account