Connecting Lotus notes from SQL Server

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

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

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

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

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