>How about using auth with as400 users. Is it possible? I'm not sure about it since I'm still new for web2py but your problem should be related to the permission just like your error says.
My library is like... Object secured by authorization list . . . . . . . . . . . . *NONE Object User Group Authority *PUBLIC *CHANGE QSECOFR *ALL and my user has... Special authority . . . . . . . SPCAUT *ALLOBJ Maybe create new library and connect with the most high authority user might help. On Sep 6, 4:49 pm, António Ramos <[email protected]> wrote: > 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-p...
