ODBC

Links

• Database

Install

Download and install the mx Base package from http://www.egenix.com/files/python/eGenix-mx-Extensions.html:

egenix-mx-base-2.0.6.win32-py2.4.exe

Install mx ODBC classes:

egenix-mx-commercial-2.0.6.win32-py2.3.exe

Sample

The following code will access all bills:

#databaseConnectionODBC.py

import mx.ODBC.Windows

class databaseConnectionODBC(object):
  "Database Connection Class"
  def __init__(self, dsn = 'CS01SUPPORT'):
      self.db = mx.ODBC.Windows.DriverConnect('DSN=' + dsn + ';UID=Master;PWD=gooFball;')

  def getCursor(self):
      return self.db.cursor()

#convert.py

from databaseConnectionODBC import databaseConnectionODBC

class convertBills(object):
  def convert(self, databaseConnection):
      sql = 'select * from bills'

      cursor = databaseConnection.getCursor()
      cursor.execute(sql)

      while(True):
          data = cursor.fetchone()
          if data == None:
              break;

          print '#####################################################################'
          for field in data:
              print field


if __name__ == '__main__':
  databaseConnection = databaseConnectionODBC('CS01PatTemp')
  bills = convertBills()
  bills.convert(databaseConnection)