Hi,
I'm trying to use SqlSoup with firebird backed.
My environment is: python 2.6, sqlalchemy 0.6.3 all in virtualenv.
The firebird version is 2.1
I do all steps to do a simple test:
db = SqlSoup('firebird://SYSDBA:[email protected]/home/maxi/
databases/test.fdb')
people = db.people.all()
for p in people:
print p.name
When SqlSoup tries to execute: people = db.people.all() I get the
next Traceback
Traceback (most recent call last):
File "pru.py", line 24, in <module>
people = db.people.all()
File "/home/maxi/.virtualenvs/miskred/lib/python2.6/site-packages/
sqlalchemy/ext/sqlsoup.py", line 550, in __getattr__
return self.entity(attr)
File "/home/maxi/.virtualenvs/miskred/lib/python2.6/site-packages/
sqlalchemy/ext/sqlsoup.py", line 539, in entity
table = Table(attr, self._metadata, autoload=True,
autoload_with=self.bind, schema=schema or self.schema)
File "/home/maxi/.virtualenvs/miskred/lib/python2.6/site-packages/
sqlalchemy/schema.py", line 209, in __new__
table._init(name, metadata, *args, **kw)
File "/home/maxi/.virtualenvs/miskred/lib/python2.6/site-packages/
sqlalchemy/schema.py", line 257, in _init
include_columns=include_columns)
File "/home/maxi/.virtualenvs/miskred/lib/python2.6/site-packages/
sqlalchemy/engine/base.py", line 1772, in reflecttable
conn = self.contextual_connect()
File "/home/maxi/.virtualenvs/miskred/lib/python2.6/site-packages/
sqlalchemy/engine/base.py", line 1742, in contextual_connect
self.pool.connect(),
File "/home/maxi/.virtualenvs/miskred/lib/python2.6/site-packages/
sqlalchemy/pool.py", line 158, in connect
return _ConnectionFairy(self).checkout()
File "/home/maxi/.virtualenvs/miskred/lib/python2.6/site-packages/
sqlalchemy/pool.py", line 329, in __init__
rec = self._connection_record = pool.get()
File "/home/maxi/.virtualenvs/miskred/lib/python2.6/site-packages/
sqlalchemy/pool.py", line 177, in get
return self.do_get()
File "/home/maxi/.virtualenvs/miskred/lib/python2.6/site-packages/
sqlalchemy/pool.py", line 692, in do_get
con = self.create_connection()
File "/home/maxi/.virtualenvs/miskred/lib/python2.6/site-packages/
sqlalchemy/pool.py", line 138, in create_connection
return _ConnectionRecord(self)
File "/home/maxi/.virtualenvs/miskred/lib/python2.6/site-packages/
sqlalchemy/pool.py", line 213, in __init__
self.connection = self.__connect()
File "/home/maxi/.virtualenvs/miskred/lib/python2.6/site-packages/
sqlalchemy/pool.py", line 279, in __connect
connection = self.__pool._creator()
File "/home/maxi/.virtualenvs/miskred/lib/python2.6/site-packages/
sqlalchemy/engine/strategies.py", line 76, in connect
return dialect.connect(*cargs, **cparams)
File "/home/maxi/.virtualenvs/miskred/lib/python2.6/site-packages/
sqlalchemy/engine/default.py", line 238, in connect
return self.dbapi.connect(*cargs, **cparams)
File "/home/maxi/.virtualenvs/miskred/lib/python2.6/site-packages/
kinterbasdb/__init__.py", line 478, in connect
return Connection(*args, **keywords_args)
File "/home/maxi/.virtualenvs/miskred/lib/python2.6/site-packages/
kinterbasdb/__init__.py", line 641, in __init__
b.dsn, b.dpb, b.dialect, timeout
sqlalchemy.exc.OperationalError: (OperationalError) (-902,
'isc_attach_database: \n I/O error for file "home/maxi/databases/
test.fdb"\n Error while trying to open file\n No such file or
directory') None None
What is wrong here?
Thanks in advance.
----
Maxi.
--
You received this message because you are subscribed to the Google Groups
"sqlalchemy" 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/sqlalchemy?hl=en.
