error Linked SQL server

[Nana]

Hi, i'm having problems with two sql servers.

server A = W2003 and SQL2000

server b = W2000 and SQL2000.

both SQL server with SP4

when we run a INSERT in a JOB from B to server A, we get this error:

"Executed as user: NT AUTHORITY\SYSTEM. OLE DB provider 'SQLOLEDB' could not
INSERT INTO table '[SERVERA].[BASETEST].[DBO].[TABLA]'. Unknown provider
error. [SQLSTATE 42000] (Error 7343) [SQLSTATE 01000] (Error 7312) OLE DB
error trace [OLE/DB Provider 'SQLOLEDB' IRowsetChange::InsertRow returned
0x80040e23: Unknown provider error.]. [SQLSTATE 01000] (Error 7300). The
step failed."

and when we run the SP on Server B we get this:

Server: Msg 7343, Level 16, State 2, Procedure USR_LC_INS_ESTAII_OFI, Line
11
OLE DB provider 'SQLOLEDB' could not INSERT INTO table
'[SERVERA].[BASETEST].[DBO].[TABLA]'. Unknown provider error.
[OLE/DB provider returned message: Cursor operation conflict]
OLE DB error trace [OLE/DB Provider 'SQLOLEDB' IRowsetChange::InsertRow
returned 0x80040e23: Unknown provider error.].


we can do SELECT between server OK.

que puede ser?

[Erland Sommarskog]

Post by Nana
Hi, i'm having problems with two sql servers.
server A = W2003 and SQL2000
server b = W2000 and SQL2000.
both SQL server with SP4
"Executed as user: NT AUTHORITY\SYSTEM. OLE DB provider 'SQLOLEDB' could
not INSERT INTO table '[SERVERA].[BASETEST].[DBO].[TABLA]'. Unknown
provider error. [SQLSTATE 42000] (Error 7343) [SQLSTATE 01000] (Error
7312) OLE DB error trace [OLE/DB Provider 'SQLOLEDB'
IRowsetChange::InsertRow returned 0x80040e23: Unknown provider error.].
[SQLSTATE 01000] (Error 7300). The step failed."

I did some research, and 0x80040E23 is DB_E_DELETEDROW, but this is
not listed as a possible return code for IRowsetChange::InsertRow. Not
that I think it would have helped much if there had been any information.

Have you tried running the INSERT on Server A instead? Usually when
you get these sort of problems with linked servers, it's better to
think of different ways to achieve what you want than fighting windmills.

[Linchi Shea]

To help troubleshooting, I'd create a simple test table on A and try to do an
INSERT into that test table from B using the linked server just to see if it
works outside out the proc at all.

Linchi

Post by Nana
Hi, i'm having problems with two sql servers.
server A = W2003 and SQL2000
server b = W2000 and SQL2000.
both SQL server with SP4
"Executed as user: NT AUTHORITY\SYSTEM. OLE DB provider 'SQLOLEDB' could not
INSERT INTO table '[SERVERA].[BASETEST].[DBO].[TABLA]'. Unknown provider
error. [SQLSTATE 42000] (Error 7343) [SQLSTATE 01000] (Error 7312) OLE DB
error trace [OLE/DB Provider 'SQLOLEDB' IRowsetChange::InsertRow returned
0x80040e23: Unknown provider error.]. [SQLSTATE 01000] (Error 7300). The
step failed."
Server: Msg 7343, Level 16, State 2, Procedure USR_LC_INS_ESTAII_OFI, Line
11
OLE DB provider 'SQLOLEDB' could not INSERT INTO table
'[SERVERA].[BASETEST].[DBO].[TABLA]'. Unknown provider error.
[OLE/DB provider returned message: Cursor operation conflict]
OLE DB error trace [OLE/DB Provider 'SQLOLEDB' IRowsetChange::InsertRow
returned 0x80040e23: Unknown provider error.].
we can do SELECT between server OK.
que puede ser?

[Emilio Boucau]

Nana,

No hagas cross-posting y respeta el idioma del foro, por favor.

Saludos !
---
Emilio Boucau
Buenos Aires - Argentina

Post by Nana
Hi, i'm having problems with two sql servers.
server A = W2003 and SQL2000
server b = W2000 and SQL2000.
both SQL server with SP4
"Executed as user: NT AUTHORITY\SYSTEM. OLE DB provider 'SQLOLEDB' could
not INSERT INTO table '[SERVERA].[BASETEST].[DBO].[TABLA]'. Unknown
provider error. [SQLSTATE 42000] (Error 7343) [SQLSTATE 01000] (Error
7312) OLE DB error trace [OLE/DB Provider 'SQLOLEDB'
IRowsetChange::InsertRow returned 0x80040e23: Unknown provider error.].
[SQLSTATE 01000] (Error 7300). The step failed."
Server: Msg 7343, Level 16, State 2, Procedure USR_LC_INS_ESTAII_OFI, Line
11
OLE DB provider 'SQLOLEDB' could not INSERT INTO table
'[SERVERA].[BASETEST].[DBO].[TABLA]'. Unknown provider error.
[OLE/DB provider returned message: Cursor operation conflict]
OLE DB error trace [OLE/DB Provider 'SQLOLEDB' IRowsetChange::InsertRow
returned 0x80040e23: Unknown provider error.].
we can do SELECT between server OK.
que puede ser?