naxom.blogg.se

SERVER= is case-sensitive some versions of iaccess driverĪdd compilation of mod (%) operator to MOD() function, casting as bigint The IBM i Access ODBC Driver is developed and licensed separately by IBM.Ĭontinuous integration testing is performed against the system available from the great guys at. This package was created with Cookiecutter and the audreyr/cookiecutter-pypackage project template. If you know what you’re doing with SQLAlchemy this package should be nearly invisible to you with the exception of the URI used to connect to the database.: # connect via hostname / ip address

Use pip to download and install the latest released version of this tool.: pip install iaccess Install via setup.pyĭownload or clone this repo and install via setup.py: python setup.py install Quickstart

If you do not happen to have an IBM Power system sitting around your house (although who doesn’t?!) you may be able to get an account to play with at. IBM i 7.2+ on your target system: Older versions of the OS may work but I have not tested against them. I Access Client Solutions ODBC driver: You’ll need this driver available only from IBM. You may also need to apt-get install unixodbc-dev if you get errors about a missing sql.h file. On Ubuntu you can install this with apt-get install unixodbc. UnixODBC (if on Linux or in PASE for i): Windows ships with ODBC installed, but on Linux you’ll need unixodbc.

Those two packages rely on and automatically install a binary driver for DB2, while this package relies on you already having install the i Access Client Solutions ODBC driver available on IBM’s support/download site. Other work in this area includes the ibm_db and ibm_db_sa projects, which also provide access to DB2 and support SQLAlchemy. On up-to-date systems (7.2+ with latest PTFs) you can also use this driver locally on your i Series machine, making local development of server code more feasible. Provides support for DB2 for iSeries for remote python clients using IBM i Access Client Solutions ODBC driver.