Use this string instead. It seems some version is Firbird do not like
setting the default encoding to UTF8.
db = SQLDB('firebird://sysdba:passw...@localhost/employee.fd?
set_encoding=None')
On Jun 21, 9:54 pm, 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
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
