home *** CD-ROM | disk | FTP | other *** search
/ Maximum CD 2010 November / maximum-cd-2010-11.iso / DiscContents / calibre-0.7.13.msi / file_2731 (.txt) < prev    next >
Encoding:
Python Compiled Bytecode  |  2010-08-06  |  3.4 KB  |  86 lines
  1. # Source Generated with Decompyle++
  2. # File: in.pyc (Python 2.6)
  3.  
  4. from win32com.client import Dispatch, DispatchWithEvents, constants
  5. import pythoncom
  6. import os
  7. import time
  8. finished = 0
  9.  
  10. class ADOEvents:
  11.     
  12.     def OnWillConnect(self, str, user, pw, opt, sts, cn):
  13.         pass
  14.  
  15.     
  16.     def OnConnectComplete(self, error, status, connection):
  17.         global finished
  18.         print 'connection is', connection
  19.         print 'Connected to', connection.Properties('Data Source')
  20.         finished = 1
  21.  
  22.     
  23.     def OnCommitTransComplete(self, pError, adStatus, pConnection):
  24.         pass
  25.  
  26.     
  27.     def OnInfoMessage(self, pError, adStatus, pConnection):
  28.         pass
  29.  
  30.     
  31.     def OnDisconnect(self, adStatus, pConnection):
  32.         pass
  33.  
  34.     
  35.     def OnBeginTransComplete(self, TransactionLevel, pError, adStatus, pConnection):
  36.         pass
  37.  
  38.     
  39.     def OnRollbackTransComplete(self, pError, adStatus, pConnection):
  40.         pass
  41.  
  42.     
  43.     def OnExecuteComplete(self, RecordsAffected, pError, adStatus, pCommand, pRecordset, pConnection):
  44.         pass
  45.  
  46.     
  47.     def OnWillExecute(self, Source, CursorType, LockType, Options, adStatus, pCommand, pRecordset, pConnection):
  48.         pass
  49.  
  50.  
  51.  
  52. def TestConnection(dbname):
  53.     c = DispatchWithEvents('ADODB.Connection', ADOEvents)
  54.     dsn = 'Driver={Microsoft Access Driver (*.mdb)};Dbq=%s' % dbname
  55.     user = 'system'
  56.     pw = 'manager'
  57.     c.Open(dsn, user, pw, constants.adAsyncConnect)
  58.     end_time = time.clock() + 10
  59.     while time.clock() < end_time:
  60.         pythoncom.PumpWaitingMessages()
  61.     if not finished:
  62.         print 'XXX - Failed to connect!'
  63.     
  64.  
  65.  
  66. def Test():
  67.     import testAccess
  68.     
  69.     try:
  70.         testAccess.GenerateSupport()
  71.     except pythoncom.com_error:
  72.         print '*** Can not import the MSAccess type libraries - tests skipped'
  73.         return None
  74.  
  75.     dbname = testAccess.CreateTestAccessDatabase()
  76.     
  77.     try:
  78.         TestConnection(dbname)
  79.     finally:
  80.         os.unlink(dbname)
  81.  
  82.  
  83. if __name__ == '__main__':
  84.     Test()
  85.  
  86.