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