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
-~----------~----~----~----~------~----~------~--~---
