Showing posts with label direct. Show all posts
Showing posts with label direct. Show all posts

Tuesday, March 20, 2012

Remote server delete

Hi,
Can any please shed some light on the following problem or direct me to an
information source ?
DELETE remoteserver.database.schema.table
returns the following error message.
iServer: Msg 7345, Level 16, State 1, Line 2
OLE DB provider 'MSDASQL' could not delete from table '"S1031118"."CISDTA6".
"DXDV36001"'. There was a recoverable, provider-specific error, such as an
RPC failure.
ODBC: Msg 0, Level 19, State 1
SqlDumpExceptionHandler: Process 106 generated fatal exception c0000005
EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.
[OLE/DB provider returned message: Multiple-step operation generated errors.
Check each status value.]
OLE DB error trace [OLE/DB Provider 'MSDASQL' IRowsetChange::DeleteRows
returned 0x80040e21: DBROWSTATUS_E_FAIL].
Any help would really be appreciated.
Message posted via webservertalk.com
http://www.webservertalk.com/Uwe/Forum...amming/200511/1What kind of Linked server is this ? (product etc.)
Jens Suessmeyer.|||Sorry about the delay.
The linked server is configured as server type: other data source
provider name:
Microsoft OLE DB provider for ODBC drivers
Jens wrote:
>What kind of Linked server is this ? (product etc.)
>Jens Suessmeyer.
Message posted via http://www.webservertalk.com