I think there's something wrong with my Firebird installation, it must
be incorrectly built or configured.
Even from the Python command line interpreter I keep getting similar
errors when executing sql commands...
On Mon, Jun 22, 2009 at 2:58 PM, Alexei
Vinidiktov<alexei.vinidik...@gmail.com> wrote:
> I've also tried commenting the lines
>
> if charset != 'None':
> self._execute('SET NAMES %s;' % charset)
>
> in sql.py but then I got this error message:
>
> Traceback (most recent call last):
> File "/var/www/alvinru/data/www/bilingsoft.ru/gluon/restricted.py",
> line 107, in restricted
> exec ccode in environment\n File
> "/var/www/alvinru/data/www/bilingsoft.ru/applications/welcome/models/db.py",
> line 57, in <module>
> auth.define_tables() # creates all needed tables
> File "/var/www/alvinru/data/www/bilingsoft.ru/gluon/tools.py", line
> 504, in define_tables
> migrate=self.__get_migrate(self.settings.table_user_name, migrate))
> File "/var/www/alvinru/data/www/bilingsoft.ru/gluon/sql.py", line
> 993, in define_table
> query = t._create(migrate=migrate)
> File "/var/www/alvinru/data/www/bilingsoft.ru/gluon/sql.py", line
> 1314, in _create
> self._db._execute(query)\n File
> "/var/www/alvinru/data/www/bilingsoft.ru/gluon/sql.py", line 864, 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 6, column 2 password\')'
>
> On Mon, Jun 22, 2009 at 2:08 PM, Alexei
> Vinidiktov<alexei.vinidik...@gmail.com> wrote:
>> 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
>>
>
>
>
> --
> 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
-~----------~----~----~----~------~----~------~--~---
