Ok, seems to get someting now.
I have to change in AS400 the permissions to allow my username to create a
table
ProgrammingError: ('42000', '[42000] [IBM][Controlador ODBC do iSeries
Access][DB2 UDB]SQL0551 - Not authorized to object **** in *N type *USRPRF.
(-551) (SQLExecDirectW)')
How about using auth with as400 users. Is it possible?
Thank you
Em 6 de setembro de 2011 22:07, António Ramos <[email protected]>escreveu:
> I tried the DAL Example and i could not connect to my AS400
> does the DAL only works with db2 on windows or linux?
>
> i have my db2 in a OS400 machine
>
>
> Thank you
>
> António
>
> Em 6 de setembro de 2011 21:56, António Ramos <[email protected]>escreveu:
>
> Great
>> i tested the example from the python shell and i connected to my company
>> AS400 with success.
>>
>> FANTASTIC!!!!
>>
>> Tomorrow i will kick the ass of the RPG guy.
>>
>> :)
>>
>>
>>
>> 2011/9/6 Massimo Di Pierro <[email protected]>
>>
>>>
>>> http://ochiba77.blogspot.com/2011/09/how-to-connect-db2-with-python-pyodbc.html
>>
>>
>>
>