I've just fixed it :D
The thing is that those parameters (that fix up the issue with clob types
and pyodbc) can be passed trough the web2py connection string, so it is now
as follows:
db_tivoli =
DAL('db2:pyodbc://driver=DB2;hostname=IP_OR_HOSTNAME;database=DATABASENAME;\
uid=USER;pwd=PASSWORD;port=50005;LONGDATACOMPAT=1;LOBMAXCOLUMNSIZE=10485875',
migrate=False, pool_size=0, attempts=1)
I'm so happy :)
El lunes, 4 de mayo de 2015, 10:56:49 (UTC-6), Boris Aramis Aguilar
Rodríguez escribió:
>
> Hi, web2py data type is text;
>
> I see in this post:
> https://groups.google.com/forum/#!searchin/web2py/ODBC$20data$20type$20-99/web2py/6xxz8KXBXCY/pcpdiPQh1K4J
> that it is the normal behavior of web2py, to map text-clob on IBM DB2
> databases.
>
> Also on the same post they propose a solution editing db2cli.ini file but
> I don't know how to configure db2cli.ini (I mean, I know how to open it,
> where it is but I don't understand which alias should I put on the file)
>
> Any help I will really appreciate it.
>
> Thanks!
>
> El sábado, 25 de abril de 2015, 5:24:41 (UTC-6), Paolo Valleri escribió:
>>
>> you should provide us more info...
>> which web2py type are you using that is mapped to CLOB field?
>> web2py/pyodbc version
>>
>> Paolo
>>
>> On Friday, April 24, 2015 at 6:17:53 PM UTC+2, Boris Aramis Aguilar
>> Rodríguez wrote:
>>>
>>> <class pyodbc.Error'> ('ODBC data type -99 is not supported. Cannot read
>>> column LDTEXT.', 'HY000')
>>>
>>> Hi, Im currently accesing a DB2 database (readonly) that is used by
>>> another application, my connection string is as follows:
>>>
>>> db_tivoli =
>>> DAL('db2:pyodbc://driver=DB2;hostname=24.50.5.5;database=MAXDB71;uid=on_usr;pwd=pass.;port=50005',
>>>
>>> pool_size=1, db_codec='latin1', migrate=False)
>>>
>>> and everything was going fine until I added a clobdata type to web2py
>>> data code
>>>
>>> And now I'm getting the error I referenced above (sorry I couldnt paste
>>> it in order, Im on my phone) Any hints I would appreciate it :)
>>
>>
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
---
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.
