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 <[EMAIL PROTECTED]> 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 [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
-~----------~----~----~----~------~----~------~--~---
