Now I receive an error message that says:
"'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 Mon, Jun 22, 2009 at 1:18 PM, mdipierro<mdipie...@cs.depaul.edu> wrote:
>
> 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
> >
>
--
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
-~----------~----~----~----~------~----~------~--~---
