[DB-SIG] What To Import???

[James Briggs]

I use both mxODBC and adodbapi to connect to various databases.

here is my 2 cents worth:

adodpapi
  - its free
  - it returns Python datetime objects
  - doesn't require an ODBC DSN to be defined on the machine for the DB
to be connected too
  - but, generates difficult to interpret errors.

therefore, perfect for distributing with working windows applications
around where I work

---

mx.ODBC
  - sure its commercial, but hardly expensive. 
  - generates nicer error messages
  - has access to standard ODBC table() and column() definition stuff
  - can switch autocommit on/off
  - but, returns the mx.DateTime datatype
  - requires DSN to be define on the PC where it is used to connect.

therefore, I often prefer to use mx.ODBC for some development and
connecting to obscure database like DB2 on AS400.


James Briggs

  


"This e-mail message is intended only for the addressee(s)
 and contains information which may be confidential. If 
 you are not the intended recipient please advise the
 sender by return email, do not use or disclose the
 contents, and delete the message and any attachments
 from your system. Unless specifically indicated, this
 email does not constitute formal advice or commitment
 by the sender or UniSuper Limited (ABN 54 006 027 121) or its 
subsidiaries.
UniSuper Management Pty Ltd (AFSL No: 235907)