Posted by ProgrammerGal on 04/13/06 04:04

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].

[Back to original message]