Database Journal
MS SQL Oracle DB2 Access MySQL PostgreSQL Sybase PHP SQL Etc SQL Scripts & Samples Links Database Forum

» Database Journal Home
» Database Articles
» Database Tutorials
MS SQL
Oracle
DB2
MS Access
MySQL
» RESOURCES
Database Tools
SQL Scripts & Samples
Links
» Database Forum
» Sitemap
Free Newsletters:
DatabaseDaily  
News Via RSS Feed


follow us on Twitter
Database Journal |DBA Support |SQLCourse |SQLCourse2
 

Featured Database Articles

MS SQL

Posted Jan 25, 2005

Connect to Lotus Domino using SQL Server Linked Server - Page 2

By Muthusamy Anantha Kumar aka The MAK

Step 6

Right click on the "Linked Server" tab in Enterprise manager and create the linked server. [Refer to Fig 1.9]


Fig 1.9

Make sure you use the same datasource name that we created in the system DSN from step 5. Also, make sure you select Microsoft OLE DB Provider for ODBC Drivers. [Refer to Fig 2.0]

In the security tab, provide the fully qualified login name and password. [Refer to Fig 2.2]

"Sunny Leone/MyDomino"

"MAK/MyDomino"

If you provide only the login name and password that you use for other heterogeneous systems, such as Sybase and oracle, you get the ODBC error message below. [Refer to Fig 2.1]


Fig 2.1


Fig 2.2

Check the necessary options in the server options tab. [Refer to Fig 2.3]


Fig 2.3

Now the Linked server to the Domino mail server is ready. All of the folders that you create in the mail server will show as Views in the Linked server as shown below. [Refer to Fig 2.4]


Fig 2.4

Step 7

Now let's access the linked server "MyNotes" using the openquery statement as shown below.

select * from openquery(MyNotes,

'Select * from Repository')

The result looks like:

Sunny Leone

1/6/2005 14:46

1227

SQL Server

MAK

1/7/2005 16:26

1802

FYI.

The MAK

1/7/2005 16:36

2571

notes

MAK

1/7/2005 16:37

1648

ODBC driver for Lotus Notes

MAK

1/10/2005 10:24

2044

Database login, password

Kate Winslet

1/10/2005 17:24

1652

Please send me details about

Kate Winslet

1/10/2005 17:33

7421

Re: Database login, password Pending

MAK

1/12/2005 9:03

1612

Discuss - Repository

MAK

1/12/2005 10:25

2797

Access to SQL Server XYZ123

Kyle Smith

1/12/2005 10:33

1509

MyDomino

Sunny Leone

1/12/2005 10:37

5399

Re MyDomino

MAK

1/12/2005 11:20

3838

None

Sunny Leone

1/12/2005 11:55

5700

None

Sunny Leone

1/12/2005 14:50

1882

reboot done

MAK

1/12/2005 15:17

1606

Re: reboot done

Sunny Leone

1/12/2005 15:27

57849

Re: reboot done

MAK

1/12/2005 15:52

3292

Re: reboot done

MAK

1/13/2005 12:45

1689

Lotus notes access

Conclusion

This article has provided a guide on how to create a SQL Server linked server that connects to IBM Lotus Domino databases.

» See All Articles by Columnist MAK



MS SQL Archives

Comment and Contribute

 


(Maximum characters: 1200). You have characters left.

 

 




Latest Forum Threads
MS SQL Forum
Topic By Replies Updated
SQL 2005: SSIS: Error using SQL Server credentials poverty 3 August 17th, 07:43 AM
Need help changing table contents nkawtg 1 August 17th, 03:02 AM
SQL Server Memory confifuration bhosalenarayan 2 August 14th, 05:33 AM
SQL Server Primary Key and a Unique Key katty.jonh 2 July 25th, 10:36 AM


















Thanks for your registration, follow us on our social networks to keep up-to-date