ADO 2.5 connection problem

[Dale Strickland-Clark]

Sorry about the length of this post but I've run out of ideas.

The following error is produced by a short extract of the program I'm
working on.

The program opens a database connection (ADO) object which it stores in the
object it returns on creation.

That connection is then used on subsequent calls to access record sets. The
test() method shows that the connection is still open.

This used to work with MDAC 2.1 but I had to upgrade to MDAC 2.5. That's
when it stopped working. This error is reproducible on NT 4.0 and Windows
2000.

HELP! Why can't I use this connection?


>>> import thstest
>>> x = thstest.ths()
Create ths...
>>> x.logon('fred', 'pw')
Traceback (innermost last):
  File "<interactive input>", line 1, in ?
  File "S:\JOBS\THS\Code\thstest.py", line 52, in logon
    rs.open(qry, self.dbcon, adOpenStatic, adLockOptimistic, adCmdText)
  File "d:\Program Files\Python\win32com\client\dynamic.py", line 428, in
__getattr__
    raise pythoncom.com_error, details
com_error: (-2147352567, 'Exception occurred.', (0, 'ADODB.Recordset',
'Operation is not allowed on an object referencing a closed or invalid
connection.', 'C:\\WINNT\\HELP\\ADO210.CHM', 0, -2146824579), None)
>>> x.test()
Connection state: 1
>>>


from win32com.client import Dispatch

# Constants

# ---- CursorTypeEnum Values ----
adOpenStatic = 3
# ---- LockTypeEnum Values ----
adLockOptimistic = 3
# ---- CommandTypeEnum Values ----
adCmdText = 0X0001

# ---- ObjectStateEnum Values ----
adStateClosed = 0X00000000
adStateOpen = 0X00000001
adStateConnecting = 0X00000002
adStateExecuting = 0X00000004
adStateFetching = 0X00000008

sourcedb = "s:\\data\\merlin.mdb"

class ths:
    def __init__(self):
        self.dbcon = Dispatch("ADODB.Connection")
        self.dbcon.Open("Driver={Microsoft Access Driver (*.MDB)}; DBQ=" +
sourcedb)
        print "Create ths..."

    def test(self):
        print "Connection state:", self.dbcon.state

    def __del__(self):
        print "Deleting ths..."
        self.dbcon.Close()
        self.dbcon = None

    def logon(self, email, password):
        rs = Dispatch("ADODB.Recordset")
        qry = "select * from user where email = '%s' and password = '%s'" %
(email, password)
        rs.open(qry, self.dbcon, adOpenStatic, adLockOptimistic, adCmdText)
        return not rs.EOF




--
Dale Strickland-Clark
Out-Think Ltd, UK
Business Technology Consultants