12 messages in com.googlegroups.sqlalchemy[sqlalchemy] Re: autoload'ing metadata| From | Sent On | Attachments |
|---|---|---|
| svilen | 25 Jul 2007 05:06 | |
| svilen | 25 Jul 2007 08:05 | |
| sdob...@sistechnology.com | 25 Jul 2007 12:39 | |
| sdob...@sistechnology.com | 25 Jul 2007 15:46 | |
| Marco Mariani | 26 Jul 2007 01:36 | |
| svilen | 26 Jul 2007 02:10 | |
| sdob...@sistechnology.com | 26 Jul 2007 10:50 | |
| Christophe de VIENNE | 27 Jul 2007 02:44 | |
| svilen | 27 Jul 2007 04:50 | |
| Christophe de VIENNE | 27 Jul 2007 06:13 | |
| Paul Johnston | 27 Jul 2007 13:06 | |
| Rick Morrison | 27 Jul 2007 13:15 |
| Subject: | [sqlalchemy] Re: autoload'ing metadata![]() |
|---|---|
| From: | Rick Morrison (rick...@gmail.com) |
| Date: | 07/27/2007 01:15:25 PM |
| List: | com.googlegroups.sqlalchemy |
MSSQL is case-sensitive, and wants to see queries to INFORMATION_SCHEMA in UPPER CASE.
See mssql.py.uppercase_table() for the gory details, or rather, THE GORY DETAILS ;-)
On 7/27/07, Christophe de VIENNE <cdev...@gmail.com> wrote:
Hi svil,
Still no luck. I don't know if the information_schema module is supposed to work well with pymssql. Anyway :
Traceback (most recent call last): File "autoload.py", line 233, in ? autoloader = AutoLoader( engine) File "autoload.py", line 100, in __init__ me.table_names = engine.execute( sqltext) File "/home/cdevienne/prog/sqlalchemy/lib/sqlalchemy/engine/base.py", line 773, in execute return connection.execute(statement, *multiparams, **params) File "/home/cdevienne/prog/sqlalchemy/lib/sqlalchemy/engine/base.py", line 517, in execute return Connection.executors[c](self, object, *multiparams, **params) File "/home/cdevienne/prog/sqlalchemy/lib/sqlalchemy/engine/base.py", line 557, in execute_clauseelement return self.execute_compiled(elem.compile(dialect=self.dialect, parameters=param), *multiparams, **params) File "/home/cdevienne/prog/sqlalchemy/lib/sqlalchemy/engine/base.py", line 568, in execute_compiled self._execute_raw(context) File "/home/cdevienne/prog/sqlalchemy/lib/sqlalchemy/engine/base.py", line 581, in _execute_raw self._execute(context) File "/home/cdevienne/prog/sqlalchemy/lib/sqlalchemy/engine/base.py", line 599, in _execute raise exceptions.SQLError(context.statement, context.parameters, e) sqlalchemy.exceptions.SQLError: (DatabaseError) internal error (SQL Server message 208, severity 16, state 1, line 1: Invalid object name 'information_schema.tables'. DB-Lib error message 20018, severity 5: General SQL Server error: Check messages from the SQL Server. ): SQL Server message 208, severity 16, state 1, line 1: Invalid object name 'information_schema.tables'. DB-Lib error message 20018, severity 5: General SQL Server error: Check messages from the SQL Server. 'SELECT tables_a3c4.table_name, tables_a3c4.table_schema \nFROM information_schema.tables AS tables_a3c4 \nWHERE tables_a3c4.table_schema = %(tables_table_schema)s' {'tables_table_schema': 'sf_tmp'}
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to sqla...@googlegroups.com
To unsubscribe from this group, send email to
sqla...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en
-~----------~----~----~----~------~----~------~--~---




