Has Anyone Seen This Access Exception?

  • I am running SQL Server 2K SP 4.  Yesterday I encountered this error that brought our server to a near standstill.

                            Error: 0, Severity: 19, State: 0 SqlDumpExceptionHandler: Process 65 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.

     

    And

     

                            Error: 0, Severity: 19, State: 0 language_exec: Process 65 generated an access violation. SQL Server is terminating this process.

    I have found the stored proc that failed and this particular line concerns me

     Insert into AS400PROD.S1098E9E.CPCLIBOBJ.FFPPPREJA

     Select *

     From PWReports..TransferFraudsToAS400

    It concerns me because I have found that error occurs in SQL 7.0 using linked servers. 

    Does anyone have anymore info or experience with this error?  I would love to be able to answer why this occurred.

    Thanks

  • I go the same exact message when I created a linked server to a Provide X (unknown) database using a ODBC driver. The server gets linked but when I use the four part name to select records from a table, the error comes up. But I can successfully read records when I create a DTS package instead of a linked server or a distributed query. It looks like a permission issue. Let me know if you had any luck!!

    Thanks,

  • Did the procedure work before you upgraded to service pack 4?  Can you do a select successfully?  What ODBC driver are you using to connect to your AS400?  Have you tried using OpenQuery?  Is there anything in the dump file that can help you?  We use linked servers to an AS400 and have always had issues with inserts--possibly due to the driver translation or index issues.

    By the way, we use the Client Access iSeries 10 driver for 'select' queries and a 3rd party driver called HiT for inserts, updates, etc.  Good luck.

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

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