I am connecting to a PostgreSQL database from a .Net web service (both on a Windows XP machine). On a few occasions recently, on a few different computers, we have received System.AccessViolationException errors.
One stack trace I was able to obtain showed that it was occuring when I took an ADODB.recordset and obtained the value of a field. e.g.
Dim rs as ADODB.Recordset = 'initialize recordset via a query to database
MsgBox(rs("fieldName").Value)
This does not always fail; it rarely fails. We ran memtest on one of the computers and found no problems.
What could the problem be? If it's the driver, what are my options?