OK, I've just set up Firebird 2.1.2 on my Windows XP box with
kinterbasdb 3.3, and using it from web2py gives exactly the same error
messages as on the Linux box.
On Windows I can also successfully manipulate Firebird databases via
the command line Python interpreter.
What else can I do to narrow down the scope of the problem?
On Mon, Jun 22, 2009 at 6:54 PM, Alexei
Vinidiktov<alexei.vinidik...@gmail.com> wrote:
> I think I spoke too soon. It may be configured correctly.
>
> I have successfully retrieved data from the database using a select
> command via command line Python like this:
>
> import kinterbasdb
>
> con = kinterbasdb.connect(
> host='localhost', database='employee.fdb',
> user='sysdba', password='password'
> )
>
>
> cur = con.cursor()
> cur.execute('select * from COUNTRY;')
> print cur.fetchall()
>
> I've also successfully created a new table:
>
> cur.execute('create table PERSON1 ( PERSON_ID BIGINT NOT NULL,
> FIRST_NAME VARCHAR(35));')
> con.commit()
>
> So the question remains why web2py gives me errors...
>
> On Mon, Jun 22, 2009 at 6:37 PM, Alexei
> Vinidiktov<alexei.vinidik...@gmail.com> wrote:
>> 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
>>
>
>
>
> --
> 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
-~----------~----~----~----~------~----~------~--~---
