The error below is due to the fact that

ma=SQLDB('firebird://dbuser:dbpass/127.0.0.1:3050//drugref.fdb')

should probably be

ma=SQLDB('firebird://dbuser:dbpass/127.0.0.1:3050/drugref.fdb')

but things do not add up. The problem with SET NAMES is at line 763
and the problem below is at line 742. The order in which you are
getting these errors does not make sense.

Are you connecting more than once to the same database?
Is this an existing database?

Massimo


On Mar 10, 9:22 pm, Horst Herb <my.list.subscripti...@gmail.com>
wrote:
> On Wed, Mar 11, 2009 at 12:43 PM, mdipierro <mdipie...@cs.depaul.edu> wrote:
>
> > I am not a Firbeird expert but I can help you debug this.
> > Can you execute that line from a normal sql shell?
> >>     self._execute('SET NAMES UTF8;')
>
> Funny thing - in an SQL shell (isql-fb) I can.
> Going into python shell, importing the driver kinterbasdb, and
> executing this query throws the same error as in web2py
>
> However, after commenting this statement I get another 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 13, in <module>
>     ma=SQLDB('firebird://dbuser:dbpass/127.0.0.1:3050//drugref.fdb')
>   File "/home/hherb/src/web2py/gluon/sql.py", line 742, in __.py init__
>     user = m.group('user')
> AttributeError: 'NoneType' object has no attribute 'group'
>
>  This regardless whether the auth/crud staff is defined/used in model/db or 
> not
> Is firebird support broken or am I doing anything wrong?
>
> Horst
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups 
"web2py Web Framework" group.
To post to this group, send email to web2py@googlegroups.com
To unsubscribe from this group, send email to 
web2py+unsubscr...@googlegroups.com
For more options, visit this group at 
http://groups.google.com/group/web2py?hl=en
-~----------~----~----~----~------~----~------~--~---

Reply via email to