Re: [web2py] blog post on web2py + db2

2015-10-31 Thread Massimo Di Pierro
This is what the examples indicate as db2 syntax, and it depends on the driver you have 'db2:ibm_db_dbi://DSN=dsn;UID=user;PWD=pass' 'db2:pyodbc://driver=DB2 ;hostname=host;database=database;uid=user;pwd=password;port=port' On Saturday, 31 October 2015 17:12:11

Re: [web2py] blog post on web2py + db2

2015-10-31 Thread ffkcum
I have the same situation here, manage to connect as400 from the shell, but if i use web2py it fails Is this problem already has a solution? If yes, please advise THX On Tuesday, September 6, 2011 at 2:07:50 PM UTC-7, Ramos wrote: > > I tried the DAL Example and i could not connect to my

Re: [web2py] blog post on web2py + db2

2011-09-06 Thread António Ramos
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

Re: [web2py] blog post on web2py + db2

2011-09-06 Thread António Ramos
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 escreveu: > Great > i tested the example from the python shell and i connected to

Re: [web2py] blog post on web2py + db2

2011-09-06 Thread António Ramos
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 > > http://ochiba77.blogspot.com/2011/09/how-to-connect-db2-with-python-pyodbc.html

[web2py] blog post on web2py + db2

2011-09-06 Thread Massimo Di Pierro
http://ochiba77.blogspot.com/2011/09/how-to-connect-db2-with-python-pyodbc.html