SQL Server - Connecting Lotus notes from SQL Server
Asked By Raghavendra Selvan
09-Feb-10 10:04 AM
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
Web Star replied to Raghavendra Selvan
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
Kim van den Berg replied to Raghavendra Selvan
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
Kim van den Berg replied to Raghavendra Selvan
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
Kim van den Berg replied to Kim van den Berg
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
choosen the Blog post from here This means the installation should be on a single server as Domain Controller , as MS SQL database server and as MOSS2007 server farm. Only one uses should be used. Thats what I have done, I followed the I am reading the logfiles placed under "c: \ program files \ common files \ microsoft shared \ web server extensions \ 12 \ logs". I don't find any relavant information regarding authentication or what else 05.38 OWSTIMER.EXE (0x0980) 0x0988 Windows SharePoint Services Topology 9e7d Medium Initializing the configuration database connection. 03 / 04 / 2010 13:53:11.35 OWSTIMER.EXE (0x0980) 0x0988 Windows SharePoint Services Database 880i High System.Data.SqlClient.SqlException: Die von der Anmeldung angeforderte 'SharePoint_07_Config'-Datenbank kann nicht
There is an error like Error :The project could not be deployed to the 'localhost' server because of the following connectivity problems : A connection cannot be made. Ensure that the server is running. To verify or update the name of the target server, right-click on the project in Solution Explorer, select Project Properties, click on the Deployment tab, and then enter the name of the server. i m not able to deploy. Plz tell me wht are the configuration of this http: / / msdn.microsoft.com / en-us / library / ms175672.aspx For cube building, you can use SQL Server 2000 Analysis Services, SQL Server 2005 Analysis Services, or SQL Server 2008 Analysis Services. This article
Any one send frequently asked Important questions in C# .Net, ADO .Net, Asp .Net and Sql Server. . . . . . . . tx in Advance. . . . . . Hi, Find this. . (B)What is an IL? (B)What is a objects in Remoting? (A) What are the ways in which client can create object on server in CAO model? (A) Are CAO stateful in nature? (A) To create objects in CAO page ? (I) Can we post and access view state in another application? (I) What is SQL Cache Dependency in ASP.NET 2.0? (I) How do we enable SQL Cache Dependency in ASP.NET 2.0? (I) What is Post Cache substitution? (I) Why Config”? (B) What is a SESSION and APPLICATION object? (A) What is the difference between ‘Server.Transfer’ and ‘response. Redirect’ ? (A)What is the difference between Authentication and authorization? (I) what proper? (A) If client side validation is enabled in your Web page, does that mean server side code is not run. (A)Which JavaScript file is referenced for validating the validators A)What is the use of <%@ page aspcompat = true %> attribute? B) Explain the differences between Server-side and Client-side code? (I)Can you explain Forms authentication in detail? (A)How
History of sharepoint from 2000 can i get the history of sharepoint from the beginning. . ? Microsoft SharePoint is a web broader platform of web technologies, capable of being configured to suit a wide range of solution areas. SharePoint is designed as a broad, central application platform for common enterprise web requirements platform for custom developed applications. SharePoint is capable of supporting multiple organizations on a single 'server farm'. Microsoft provides SharePoint Foundation at no cost, but sells premium editions with additional functionality a-history-lesson.aspx In 2007, Microsoft will release the third version of their SharePoint server product - Microsoft Office SharePoint Server 2007 (MOSS 2007). It will provide a wide variety of features that make it a or future :-) It's particularly relevant to this post, given I worked for Microsoft from 2000 - 2005 and at one point was the UK lead for SharePoint. 1997 - 1999 Before SharePoint arrived, there was a product called Site Server (and Site Server Commerce Edition) that contained features including: web content management and replication, site analytics, personalization, indexing