Post reply

Update notes db through linked server

  • February 16, 2005 at 2:13 pm

    #87530

    I just read the recent article "Connect to a lotus Domino using SQL Server Linked Server" posted here.  It was great, I was able to link to and query many data sources here.  However, when I tried to update the tables I got the error

    update LNKSVR...Employee_Identification set AssetTag='12345' where ID=' 654321'

    Error:

    OLE DB provider 'MSDASQL' reported an error. The provider did not support an interface.

    Has anyone had any success with this??

     

    Regards,

    Chris Hahm

  • February 18, 2005 at 7:08 am

    #543067

    Am I posting to the wrong place?

    Regards,

    Chris Hahm

  • February 22, 2005 at 12:28 pm

    #543542

    Chris,

    I am not that familiar with Domino/Lotus Notes but could this be a permission issue?

  • February 22, 2005 at 12:46 pm

    #543545

    DSP,

    Unfortunately, I was unable to find a solution in SQL Server. However, I was able to hack together a perl script to accomplish what I needed.  I would be happy to share the script if anyone is interested.

    Regards,

    Chris Hahm

  • June 15, 2006 at 12:45 pm

    #644056

    I am looking for the article 'Connect to a lotus Domino using SQL Server Linked Server', it seems to be missing now.  Can anyone tell me how to find it or even better send it to me,

    TIA,

    Miles

  • June 16, 2006 at 7:37 am

    #644261

     

    http://www.databasejournal.com/features/mssql/article.php/3462011

    Regards,

    Chris Hahm

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply