Groups | Blog | Home
all groups > sql server odbc > july 2004 >

sql server odbc : Cannot update record through vb or Enterprise manager


John
7/2/2004 3:37:46 AM
When trying to update a specific row in a table an error
occurs.
[Microsoft][ODBC SQL SERVER DRIVER][SQL SERVER]
SQLDumExceptionhandler. Process 51 generated fatal
exception c0000005 ACCEPTION_ACCESS_VIOLATION. SQL Server
is terminating this process.

What could be the reason for this? There are no relations
Andy Ball
7/2/2004 12:44:59 PM
What build of SQL Server is it ? Would suggest

I would run DBCC CHECKDB to check for corruption / specifically DBCC
CHECKTABLE on the table being queried

I would then look at the last SQL Server Errorlog when it happened and see
if there are any matches on http://www.microsoft.com/support for kb's that
have a similar pattern ie on the Short Stack Dump info reported. Below is
an example - so if you had this output I would search the kb and google
(groups and web) for Fill6Xdata . Be aware that some of the function calls
are quite generic so watch out for false positives.

Ideally you should open a case with PSS

-
Short Stack Dump

0069EF5F Module(sqlservr+0029EF5F) (Fill6xData(unsigned char *,class
CXVariant *,class CTypeInfo const *,unsigned long *)+0000009A)
0069BEDE Module(sqlservr+0029BEDE) (intnl_paramdata(struct srv_proc
*,int)+000000DB)

regards,
Andy.


[quoted text, click to view]

AddThis Social Bookmark Button