aioodbc with iseries DB2

[ashga...@gmail.com]

hello

I work with DB2 on old iSeries v6r1 from IBM for a few now, and everything is fine using python 2.7 with pyodbc, with unix or windows 10 clients.

I was discovering your libs, and wonder if it's ok with my setup, and the answer is YES, at least on windows.
So, if you have a working ODBC install, you just have to adjust your dsn from the basic example, and you're all set!

for info, my working dsn:

'DRIVER=iSeries Access ODBC Driver; SYSTEM=db_host; UID=user; PWD=password; DBQ=default_lib; EXTCOLINFO=1; Charset=utf-8'

some included options may not be needed, depending on your settings.

I don't test it yet on unix, since my setup don't provide python 3.5, but since I transpose my windows py2.7/pyodbc to py3.5/aioodbc flawlessly, I can't see why it should not work the same on unix.

if you have questions or comments, just let me know, I'll try to answer it.

[Nickolai Novik]

Thank you for kind feedback!

To be honest aioodbc works on top of pyodbc, so python3.5 and pyodbc should work too. This is good news anyway,  I have not tested aioodbc on windows and DB2 :)

[ashga...@gmail.com]

honestly, I give a 5min look to aio-libs before thinking "run a quick test? challenge accepted!"

I should confirm for linux, but as it's on top of pyodbc, I think I'll pass: I use it with same settings/dsn since years, no matter windows or linux :)
DB2/iseries are not as common as other SQL, so I put a flag.