Discussion:
Is this related to a MySql ODBC driver?
(too old to reply)
Jeff
2007-05-26 11:34:30 UTC
Permalink
I'm still a bit new to running a server, using mysql, using databases in
general, and writing code to access those databases.

I have a web application written in visual basic.net that was running fine a
few weeks ago but is now drawing periodic errors. ...but the application is
still being developed, so there were changes there, other changes on the
server, etc all at the same time. I'm hoping that someone can give me a hint
at whether what is going on is a hardware issue, issue with the application,
issue with IIS6, or issue with Mysql. As near as I can tell, it may be a bug
with the mysql odbc driver version 3.15.12. Since the error does not occur
regularly - I can't at all re-produce it, so it is difficult to track down
for me. It always occurs in the same place, however, when the code attempts
to open a connection to mysql via odbc.

The message I get in the application is below and there are corresonding and
more detailed error messages in the server's event log that I've also
listed. I thought that this might be a hardware issue, so I pulled one of
two sticks of ram and the problem didn't return for about a week but it has
now returned.

"Attempted to read or write protected memory. This is often an indication
that other memory is corrupt."

w3wp.exe apparently refers to a process in IIS, but the errors are also
mentioning odbc - and I don't regularly read server errors, so I'm not sure
exactly what to make of this. I'm about ready to change the driver to the
newest 3.15.15, but was hoping that someone might be able to tell me more
definitely what might be occurring here. Could this be something other than
the mysql driver?

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


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
Jeff
2007-05-26 11:38:56 UTC
Permalink
Post by Jeff
issue with IIS6, or issue with Mysql. As near as I can tell, it may be a
bug with the mysql odbc driver version 3.15.12.
Oops, that was supposed to be 3.51.12
--
Posted via a free Usenet account from http://www.teranews.com
Loading...