I am not a Firbeird expert but I can help you debug this. Can you execute that line from a normal sql shell?
Massimo On Mar 10, 5:21 pm, Horst <[email protected]> wrote: > See error traceback below - the same code, run through sqlite or > postgres works just fine. > However, during a transitional period, I have to use an already > existing firebird database. > Any idea how this error could be fixed? I have tried with both > firebird 2.0 and firebird 2.1 servers. Accessing the database with > python+ kinterbasdb driver works just fine > The error happens regardless whether I define any tables or not, > regardless whether I use auth etc. or not - even an empty models/db.py > excpet for the db=... line) will trigger the error > > Traceback (most recent call last): > File "/home/hherb/src/web2py/gluon/restricted.py", line 98, in > restricted > exec ccode in environment > File "/home/hherb/src/web2py/applications/drugref/models/db.py", > line 5, in <module> > db=SQLDB('firebird://dbuser:[email protected]:3050/drugref.fdb') > File "/home/hherb/src/web2py/gluon/sql.py", line 762, in __init__ > self._execute('SET NAMES UTF8;') > File "/home/hherb/src/web2py/gluon/sql.py", line 761, in <lambda> > **b) > OperationalError: (-901, 'begin transaction: \n invalid parameter in > transaction parameter block') --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "web2py Web Framework" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/web2py?hl=en -~----------~----~----~----~------~----~------~--~---
