I have set up and configured NotesSQL on a Windows 2003 server. I was able to add a system DSN that points to a test database on my Domino development server. So far so good.
What I ultimately want to do is to add a trigger to a SQL Server database table that monitors for updates and then update a corresponding Notes database.
I basically am wondering how to talk to the datasource through SQL code that will run on the SQL server. I found this article on Database Journal:
It outlines how to set up the datasource as a "Linked Server". I did this and was able to query the datasource via the "openquery" statement. However, I am wondering how I can just to a simple statement like this:
select * from vwTest
Management Studio is unaware of the database unless I use the "openquery" statement. I guess the problem is that I don't know how to reference the datasource from SQL Server Management Studio. It seems simple and I would appreciate it if anyone could lend a hand.
Thanks in advance!