Firstly, a word of advice.
You are using Microsoft Windows Mail as your news reader so I recommend that
you connect directly to msnews.mocrosoft.com to access this and other MS
provided newsgroups. If you do then you won't have to worry about 'some
problem with your newgroup provider'.
Now to the issue at hand.
The message, "Attempted to read or write protected memory. This is often an
indication
that other memory is corrupt.", is a message associated with an
AccessViolationException which is defined as follows:
An access violation occurs in unmanaged or unsafe code
when the code attempts to read or write to memory that
has not been allocated, or to which it does not have
access. This usually occurs because a pointer has a bad
value. Not all reads or writes through bad pointers lead
to access violations, so an access violation usually
indicates that several reads or writes have occurred
through bad pointers, and that memory might be corrupted.
Thus, access violations almost always indicate serious
programming errors. In the .NET Framework version 2.0, an
AccessViolationException clearly identifies these serious
errors.
In programs consisting entirely of verifiable managed code,
all references are either valid or null, and access
violations are impossible. An AccessViolationException
occurs only when verifiable managed code interacts with
unmanaged code or with unsafe managed code.
I don't know where you got the impression that the memory chips might be at
fault but that is well wide of the mark. If your memory chips started
playing up then I suspect that you would probably not even be able to boot
the computer in question.
While the database it self might not be the problem, the ODBC driver you are
using certainly is and it certainly will contain some unmanaged code. This
is clearly indicated in the extract from the event log, so that is where you
need to start.
We can't really be of anymore help at this stage because we have no idea
what ODBC driver you are using.
"Jeff" <none@nothingX.comwrote in message
news:46578ca3$0$16396$88260bb3@free.teranews.com.. .
Quote:
>
Okay, I'm still new to vb.net 2005 - throught this was a hardware problem,
but now I don't know.
(I'm having some problem with my newgroup provider, so hopefully this will
go through)
>
This problem just started about a week ago, before all was fine. I'm using
the code below to access a mysql database. On the line indicated when the
connection is opened, the application has been sporatically drawing an
error. It doesn't occur very often - so I don't understand what's going
on. The app reports
>
"Attempted to read or write protected memory. This is often an indication
that other memory is corrupt."
>
Okay - so perhaps a bad stick of memory - so I pulled one of the two
sticks temporarily and the problem seemed to go away. Nothing for about a
week. ...but now I got the same error. I get similar errors in the event
log of the server (W2K3 IIS6).
>
I can't see how this has anything to do with my code since the problem is
only periodic. I don't know if it is due to the underlying visual studio,
but if I understand correctly, w3wp.exe refers to IIS. there is nothing in
any error messages referring to mysql, so I can't see that the database is
the problem.
>
Can anyone tell me what might be going on?
>
Jeff
>
>
Try
Dim MyCommand As New OdbcCommand(sb.ToString, MyConn)
MyCommand.CommandType = CommandType.Text
MyConn.Open() ' drawing the
bad memory error here also.
Dim dr As OdbcDataReader =
MyCommand.ExecuteReader(CommandBehavior.SingleRow)
Using (dr)
>
>
Event Type: Error
Event Source: COM+
Event Category: Unknown
Event ID: 4786
Date: 5/25/2007
Time: 8:45:16 PM
User: N/A
Description:
The system has called a custom component and that component has failed and
generated an exception. This indicates a problem with the custom
component. Notify the developer of this component that a failure has
occurred and provide them with the information below.
Component Prog ID: 0[ODBC][Env e6f14e8]
Method Name: IDispenserDriver::DestroyResource
Process Name: w3wp.exe
Exception: C0000005
Address: 0x7C82F583
Call Stack:
ntdll!RtlGetLastWin32Error + 0xc0
ntdll!RtlAllocateHeap + 0x58d
myodbc3!LoadByOrdinal + 0x560
myodbc3!SQLTransact + 0x9018
>
>
For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.
>
Event Type: Error
Event Source: Application Error
Event Category: (100)
Event ID: 1000
Date: 5/25/2007
Time: 8:45:16 PM
User: N/A
Description:
Faulting application w3wp.exe, version 6.0.3790.1830, faulting module
ntdll.dll, version 5.2.3790.1830, fault address 0x0002f583.
>
>
--
Posted via a free Usenet account from
http://www.teranews.com
>