Table Creation script fails with Sql Server 2008

[Former user]

I have a simple script that uses the meta.create_all method to create a few tables. This script works fine in SQL Server 2005 but fails with SQL Server 2008 with the following:

File "/pythonenv/main/lib/python2.6/site-packages/SQLAlchemy-0.6beta2dev-py2.6.egg/sqlalchemy/sql/compiler.py", line 1377, in _requires_quotes or value0 in self.illegal_initial_characters IndexError: string index out of range

I experienced this with the sqlalchemy .6 beta and from the trunk version with the latest pyodbc from trunk as well. Every variation I have tried works fine with mssql 2005, blows up with mssql 2008.

Running python 2.6.1

[Mike Bayer]

there is absolutely no way we can help if you do not attach a test case illustrating hte problem. Without a test this ticket will have to be closed.

[Former user]

My apologies. I am still somewhat new to this mssql, pyodbc, freetds software stack and after a few hours of frustration posted this without thinking much of proper test cases only to track down the problem to user error 5 minutes later.

Consider this problem solved and I will continue to work on the real problem, my sqlalchemy ignorance.

[Mike Bayer]

oh that's no problem at all, good luck !