Can you help me debug why? Perhaps there is a typo in the regex?
Massimo
On Jun 22, 8:23 pm, Alexei Vinidiktov <alexei.vinidik...@gmail.com>
wrote:
> Thanks, Massimo!
>
> The auth.settings.password_field='password2' thing did the trick!
>
> I'm afraid the '?set_encoding=None' thing doesn't work.
>
> As I said earlier I tried using the string that you suggested:
>
> db = SQLDB('firebird://sysdba:passw...@localhost/employee.fdb?
> set_encoding=None')
>
> but I got this error:
>
> "'isc_attach_database: I/O error for file "employee.fdb?set_encoding=None"
> Error while trying to open file. No such file or directory'"
>
>
>
> On Tue, Jun 23, 2009 at 4:46 AM, mdipierro<mdipie...@cs.depaul.edu> wrote:
>
> > ?set_encoding=None
>
> > should have the effect of not running "SET NAMES"
>
> > The other problem you have is that "password' cannot be used a field
> > name by auth because it is a reserved in firebird.
>
> > auth.settings.password_field='password2'
>
> > before auth.define_tables()
>
> > Massimo
>
> > On Jun 22, 9:42 am, Alexei Vinidiktov <alexei.vinidik...@gmail.com>
> > wrote:
> >> Thanks for your input, Jose.
>
> >> As I said earlier, I had tried commenting the lines that add SET NAMES
> >> in sql.py, and I got a different error message that I quoted in a
> >> previous email. Part of the traceback was:
>
> >> self._execute = lambda *a, **b: self._cursor.execute(*a, **b)
> >> ProgrammingError: (-104, \'isc_dsql_prepare: Dynamic SQL Error SQL
> >> error code = -104
> >> Token unknown - line 6, column 2 password\')'
>
> >> And the solution Massimo suggested didn't work either which I also
> >> reported in a previous email.
>
> >> On Mon, Jun 22, 2009 at 10:36 PM, Jose<jjac...@gmail.com> wrote:
>
> >> > On 22 jun, 02:54, Alexei Vinidiktov <alexei.vinidik...@gmail.com>
> >> > wrote:
> >> >> Hello,
>
> >> >> I'm trying to make a connection to a Firebird db file, but I keep
> >> >> getting this error:
>
> >> >> Traceback (most recent call last):
> >> >> File "/var/www/alvinru/data/www/bilingsoft.ru/gluon/restricted.py",
> >> >> line 98, in restricted
> >> >> exec ccode in environment
> >> >> File
> >> >> "/var/www/alvinru/data/www/bilingsoft.ru/applications/notebook/models/db.py",
> >> >> line 12, in <module>
> >> >> db = SQLDB(\'firebird://sysdba:passw...@localhost/employee.fdb\')
> >> >> File "/var/www/alvinru/data/www/bilingsoft.ru/gluon/sql.py", line
> >> >> 837, in __init__
> >> >> self._execute(\'SET NAMES %s;\' % charset)
> >> >> File "/var/www/alvinru/data/www/bilingsoft.ru/gluon/sql.py", line
> >> >> 835, in <lambda>
> >> >> self._execute = lambda *a, **b: self._cursor.execute(*a,**b)
> >> >> ProgrammingError: (-104, \'isc_dsql_prepare: Dynamic SQL Error SQL
> >> >> error code = -104
> >> >> Token unknown - line 1, column 5 NAMES\')'
>
> >> >> My connection string in db.py is like this:
>
> >> >> db = SQLDB('firebird://sysdba:passw...@localhost/employee.fdb')
>
> >> >> I can successfully connect to the same database from the command line:
>
> >> >> import kinterbasedb
> >> >> con = kinterbasdb.connect(
> >> >> host='localhost', database='employee.fdb',
> >> >> user='sysdba', password='password'
> >> >> )
>
> >> >> I'm using CentOS 5.2 with Python 2.5.4, Firebird 2.1.2 Super Server
> >> >> and the latest version of web2py.
>
> >> >> I'd be grateful for any clues as to what might be happening.
>
> >> >> --
> >> >> Alexei Vinidiktov
>
> >> > This had commented on it to Massimo, the instruction :
> >> > SET NAMES
> >> > It is not valid in firebird.
>
> >> > Jose
>
> >> --
> >> Alexei Vinidiktov
>
> --
> Alexei Vinidiktov
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
