There are multiple issues. The main one is that
ma=SQLDB('firebird://dbuser:dbpass/127.0.0.1:3050//drugref.fdb')
should be
ma=SQLDB('firebird://dbuser:[email protected]:3050//drugref.fdb')
The problem with SET NAMES was probably a consequence of a failure to
connect. Let me know if this fixes it.
II will be here (http://www.web2pychat.com/) for the next 1h.
Massimo
On Mar 10, 11:58 pm, Horst Herb <[email protected]>
wrote:
> On Wed, Mar 11, 2009 at 3:31 PM, mdipierro <[email protected]> wrote:
>
> > 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')
>
> No. If I omit the second "/" it searches for teh database in the local
> directory only. If I specify the database file with path the second
> '/' is required (else I get a 'database not found' error)
>
> > 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.
>
> No, they don't
>
> > Are you connecting more than once to the same database?
>
> No
>
> > Is this an existing database?
>
> Yes. And no problems firing up a python shell, connecting to it with
> the native kinterbasdb driver (which web2py uses internally too!), and
> using it
>
> 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 [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
-~----------~----~----~----~------~----~------~--~---
