I'm trying to make alive the existing application with DB2 database (currently running with PostgreSQL 9.x with no problem). I'm using latest DB2 Express version and I just find out, that all fields defined in DAL as 'text' are created in DB2 as 'CLOB' datatype. Table is created succesfully but web2py(or rather pyodbc driver ???) cant access it back and I' getting this error message: <class 'pyodbc.Error'> ('ODBC data type -99 is not supported. Cannot read column VALUE.', 'HY000')
Can anyone help with this? Is there someone using web2py with db2 succesfully ? I know its probably not the usual configuration. David