Step 6

Right click on the "Linked Server" tab in Enterprise manager and create the linked server. [Refer to 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]

Check the necessary options in the server options tab. [Refer to 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]

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:

Conclusion

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