I've managed to get SA (0.6 branch) and pyodbc connecting to an MSSQL
db on Mac OS X, but I've recently been trying to get it working on
linux (Debian Lenny) and have been hitting some problems.
It's definitely working to some degree. Adding "TDS_Version = 8.0" to
my odbc.ini fixed some unicode problems, and so now simple pyodbc
stuff seems to work. Querying seems to be fine, but sometimes adding
lots of data using the orm fails with the message: DBAPIError: (Error)
('HY000', 'The driver did not supply an error!')
The same error occurs in both SA 0.5.5 and SA 0.6
I'm going to try a few more things to narrow down a bit more where the
problem is, but if any has any ideas of what it could be or how I
could debug it, I'd be very grateful.
Thanks
Ed
PS Full stack trace follows if anyone is interested (or googling the
error)
Traceback (most recent call last):
File "/home/singletoned/.virtualenvs/nmmailer2.6/lib/python2.6/site-
packages/nose-0.11.1-py2.6.egg/nose/case.py", line 183, in runTest
self.test(*self.arg)
File "/home/singletoned/code/newman-mailserver/lib/nmmailer/tests/
test_mailing.py", line 160, in test_new_data
create_mailing_tables()
File "/home/singletoned/code/newman-mailserver/lib/nmmailer/tests/
test_mailing.py", line 131, in create_mailing_tables
create_from_data(mailing_data.data["Mailing"], nt.Mailing, session)
File "/home/singletoned/code/newman-mailserver/lib/nmmailer/
utils.py", line 54, in create_from_data
session.commit()
File "/home/singletoned/src/sa06/lib/sqlalchemy/orm/session.py",
line 673, in commit
self.transaction.commit()
File "/home/singletoned/src/sa06/lib/sqlalchemy/orm/session.py",
line 378, in commit
self._prepare_impl()
File "/home/singletoned/src/sa06/lib/sqlalchemy/orm/session.py",
line 362, in _prepare_impl
self.session.flush()
File "/home/singletoned/src/sa06/lib/sqlalchemy/orm/session.py",
line 1358, in flush
self._flush(objects)
File "/home/singletoned/src/sa06/lib/sqlalchemy/orm/session.py",
line 1436, in _flush
flush_context.execute()
File "/home/singletoned/src/sa06/lib/sqlalchemy/orm/unitofwork.py",
line 259, in execute
UOWExecutor().execute(self, tasks)
File "/home/singletoned/src/sa06/lib/sqlalchemy/orm/unitofwork.py",
line 751, in execute
self.execute_save_steps(trans, task)
File "/home/singletoned/src/sa06/lib/sqlalchemy/orm/unitofwork.py",
line 766, in execute_save_steps
self.save_objects(trans, task)
File "/home/singletoned/src/sa06/lib/sqlalchemy/orm/unitofwork.py",
line 757, in save_objects
task.mapper._save_obj(task.polymorphic_tosave_objects, trans)
File "/home/singletoned/src/sa06/lib/sqlalchemy/orm/mapper.py",
line 1387, in _save_obj
c = connection.execute(statement.values(value_params), params)
File "/home/singletoned/src/sa06/lib/sqlalchemy/engine/base.py",
line 984, in execute
return Connection.executors[c](self, object, multiparams, params)
File "/home/singletoned/src/sa06/lib/sqlalchemy/engine/base.py",
line 1047, in _execute_clauseelement
return self.__execute_context(context)
File "/home/singletoned/src/sa06/lib/sqlalchemy/engine/base.py",
line 1069, in __execute_context
self._cursor_execute(context.cursor, context.statement,
context.parameters[0], context=context)
File "/home/singletoned/src/sa06/lib/sqlalchemy/engine/base.py",
line 1126, in _cursor_execute
self._handle_dbapi_exception(e, statement, parameters, cursor,
context)
File "/home/singletoned/src/sa06/lib/sqlalchemy/engine/base.py",
line 1124, in _cursor_execute
self.dialect.do_execute(cursor, statement, parameters,
context=context)
File "/home/singletoned/src/sa06/lib/sqlalchemy/engine/default.py",
line 172, in do_execute
cursor.execute(statement, parameters)
DBAPIError: (Error) ('HY000', 'The driver did not supply an error!')
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to sqlalchemy@googlegroups.com
To unsubscribe from this group, send email to
sqlalchemy+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en
-~----------~----~----~----~------~----~------~--~---
