Post reply

Server: Msg 7343, Level 16, State 2, Line 1

  • October 16, 2007 at 4:55 am

    #70255

    I am trying to insert data in remote server which is an sql server 2000 database . while inserting following error message is received:--

    -----------------------------------------------------------

    Server: Msg 7343, Level 16, State 2, Line 1

    OLE DB provider 'SQLOLEDB' could not INSERT INTO table

    '[jhingurda].[northwind].[dbo].[e_bidder_hdr_t1]'. 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.].

    ----------------------------------------------------------------------

    Can somebody give me solution for the above..

  • October 17, 2007 at 2:10 am

    #742603

    Can you post the relevant section of your VBA code, and any info about the table that is failing to insert rows, e.g. primary key, any constraints?

  • December 23, 2010 at 2:52 am

    #1265826

    Not sure if you were able to resolve the issue but I got the same error and it turned out to be a issue with the Linked server and what was cataloged. Basically the user did not have permissions to see the objects on the server on the link server and hence the catalog only brings the stuff across that the user has got access to. I know it is several years since this occurred but thought I post it if anyone else got the issue.

Viewing 3 posts - 1 through 2 (of 2 total)

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