On Wed, Jan 03, 2018 at 10:12:32AM -0500, Andrei Stebakov wrote: > Pierce, I couldn't find any smalltalk framework to work with DB2 at this > point. I couldn't also find any Pharo odbc library. That's why at this > point I am looking for any ideas how to connect to DB2 from Pharo.
I suppose Instantiations VA Smalltalk will be able to talk to DB2. I'm quite sure Dolphin Smalltalk does ODBC too. Staying with Pharo, assuming you have known-working DB2 ODBC driver for Windows installed and ODBC to DB2 configured, try this: http://smalltalkhub.com/#!/~PharoExtras/ODBC/ Most recent commit was in Apr 2015 by Torsten 'switching to newer FFI'. So hopefully this works with Pharo 6.1. If the above doesn't work, but you know that the Windows DB2 ODBC driver works, then - I'm not being facetious - install PostgreSQL, set up PostgreSQL foreign data wrapper to ODBC, and talk to PostgreSQL using Pharo. http://www.postgresonline.com/journal/archives/372-ODBC-FDW-now-supports-9.5-and-9.6.html Or, set up Python's SQL Alchemy for DB2, install PostgreSQL, set up PostgreSQL foreign data wrapper to SQL Alchemy, and talk to PostgreSQL using Pharo. https://wiki.postgresql.org/wiki/Foreign_data_wrappers https://github.com/Kozea/Multicorn HTH.
