MS SQL Server 2000 problem

[lotfian]

I run an internet portal using SQL Server 2000. On certain functions, the servers dumps an error message "spid 51 Exception 0xc0000005 EXCEPTION_ACCESS_VIOLATION at 0x00000000
". After investigation, I have found out that this problem is solved by installing MS SQL Server 2000 service pack 1.

even though I install service pack 1 correctly, the same error still exist, and nothing is solved.

The application functions properly with SQL 7.0.

Can any of you guys help me solve this problem?

Thanks and Best regards

Lotfian

 

[tlbroadbent]

Which functions or operations cause the error? Is there any additional information in the SQL error log or the NT event log that could shed additional light on the error? What methods are used to access the database? Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.

 

[lotfian]

Dear Terry. The connection to the DB is through a connectstring file through OLEDB.

The application is a simple application for travel industry. People simply ask for an offer to a trip and the agents sends an offer. Both the agent and travellers can communicate through a Forum like communication structure.

The function that causes the problem is very simple. When a person recieves a message, he simply responses to the message. the notification will be emailed to the client and this message is also saved in the DB as a new thread to the previous message.

The funny thing is that the communication from the traveller side does not cause error. it is only the communication from the agent side that causes the error.

The following is a portion of the dump file in SQL server log.
_________________________________________________________
BEGIN STACK DUMP:
* 09/30/01 13:06:54 spid 51
*
* Exception Address = 00000000
* Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION
* Access Violation occurred reading address 00000000
* Input Buffer 260 bytes -
* exec sp_rftOfferResponse '2001093047161908',NULL,NULL,NULL,'here is the
* answer',NULL,NULL,'NA','O',NULL,'9/30/2001 1:06:54 PM','U'
_______________________________________________________

I have traced the process in the "Profiler". there is no execution error and data are inserted in the DB but it is the DB that simply generates the dumpfile.If i had you email address i would have sendt you the dump file itself.

Many thanks for your help.

 

[pmdawg]

Did you try to install SP3 for Visual Studio, I'm assuming that your front-end application is causing this error.