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