By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,266 Members | 1,297 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,266 IT Pros & Developers. It's quick & easy.

Linked Server To Lotus Notes

P: n/a
I am struggling with moving data to Lotus Notes from SQL Server.

I am hoping someone has done this and can point me in the right
direction.

I have a stored procedure that collects my data into a temp table on
sql server and I want to move that data into a Lotus Notes table.

I am select rows from #tmpCases on SQL Server and trying to put them
into CaseName on Lotus Notes.

Here is my SQL moving just one row of data:
INSERT INTO OPENQUERY([Notes_DRS_CaseName DEV],
'select
DeleteDate,
CaseName,
CaseNum,
Jurisdiction,
Entity,
OCFirm,
OCName,
OCAddress,
OCCity,
OCState,
OCZIP,
OCMainPhone,
OCDirectPhone,
OCFAX,
CaseStatus,
CasePurgeFlag,
CaseCloseDate,
CasePurgeDate,
CaseRetentionDate,
HoldReviewDate,
ReasonForHold,
UpdatedTracker
from CaseName
where 1=2')
Select
Null as DeleteDate,
CaseName,
CaseNum,
Jurisdiction,
Entity,
OCFirm,
'' as OCName,
OCAddress,
OCCity,
OCState,
OCZip,
OCMainPhone,
'' as OCDirectPhone,
OCFax,
CaseStatus,
CasePurgeFlag,
CaseCloseDate,
CasePurgeDate,
CaseRetentionDate,
null as HoldReviewDate,
null as ReasonForHold,
null as UpdatedTracker
from #tmpCases
where casenum=055344 /* where clause returns one row */

This is the error I get:
Server: Msg 7390, Level 16, State 1, Line 1
The requested operation could not be performed because the OLE DB
provider 'MSDASQL' does not support the required transaction interface.
OLE DB error trace [OLE/DB Provider 'MSDASQL' IUnknown::QueryInterface
returned 0x80004002].

Apr 13 '06 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.