great. report it to pyodbc, since I have no idea what configuration you have which would cause that:
http://groups.google.com/group/pyodbc On Jan 24, 2011, at 9:31 PM, Mark Sharp wrote: > Michael, > Back to the same error. > >>> import pyodbc > >>> > >>> conn = pyodbc.connect('DSN=frankie-w7-animal-sa;UID=sa;PWD=select $ from > >>> Bill') > >>> > >>> cursor = conn.cursor() > >>> cursor.execute(u""" > ... SELECT [COLUMNS_1].[TABLE_SCHEMA], > ... [COLUMNS_1].[TABLE_NAME], > ... [COLUMNS_1].[COLUMN_NAME], > ... [COLUMNS_1].[IS_NULLABLE], > ... [COLUMNS_1].[DATA_TYPE], > ... [COLUMNS_1].[ORDINAL_POSITION], > ... [COLUMNS_1].[CHARACTER_MAXIMUM_LENGTH], > ... [COLUMNS_1].[NUMERIC_PRECISION], > ... [COLUMNS_1].[NUMERIC_SCALE], > ... [COLUMNS_1].[COLUMN_DEFAULT], > ... [COLUMNS_1].[COLLATION_NAME] > ... FROM [INFORMATION_SCHEMA].[COLUMNS] AS [COLUMNS_1] > ... WHERE [COLUMNS_1].[TABLE_NAME] = ? AND [COLUMNS_1].[TABLE_SCHEMA] > = ? > ... ORDER BY [COLUMNS_1].[ORDINAL_POSITION] > ... """,(u'tf_valid_species', u'dbo')) > Traceback (most recent call last): > File "<stdin>", line 16, in <module> > pyodbc.ProgrammingError: ('42000', '[42000] [Actual][SQL Server] The data > types nvarchar and ntext are incompatible in the equal to operator. (402) > (SQLExecDirectW)') > > R. Mark Sharp, Ph.D. > [email protected] > > > > > On Jan 24, 2011, at 8:21 PM, Michael Bayer wrote: > >> you have a trailing comma at the end of the statement. >> >> its a long string probably easier to paste it into a .py file and run that. >> >> >> On Jan 24, 2011, at 9:06 PM, Mark Sharp wrote: >> >>> This is the result that I received. >>> >>> >>> conn = pyodbc.connect("DSN=frankie-w7-animal-sa;UID=sa;PWD=select $ >>> >>> from Bill") >>> >>> cursor = conn.cursor() >>> >>> cursor.execute(u""" >>> ... SELECT [COLUMNS_1].[TABLE_SCHEMA], >>> ... [COLUMNS_1].[TABLE_NAME], >>> ... [COLUMNS_1].[COLUMN_NAME], >>> ... [COLUMNS_1].[IS_NULLABLE], >>> ... [COLUMNS_1].[DATA_TYPE], >>> ... [COLUMNS_1].[ORDINAL_POSITION], >>> ... [COLUMNS_1].[CHARACTER_MAXIMUM_LENGTH], >>> ... [COLUMNS_1].[NUMERIC_PRECISION], >>> ... [COLUMNS_1].[NUMERIC_SCALE], >>> ... [COLUMNS_1].[COLUMN_DEFAULT], >>> ... [COLUMNS_1].[COLLATION_NAME] >>> ... FROM [INFORMATION_SCHEMA].[COLUMNS] AS [COLUMNS_1] >>> ... WHERE [COLUMNS_1].[TABLE_NAME] = ? AND >>> [COLUMNS_1].[TABLE_SCHEMA] = ? >>> ... ORDER BY [COLUMNS_1].[ORDINAL_POSITION], >>> ... """,(u'tf_valid_species', u'dbo')) >>> Traceback (most recent call last): >>> File "<stdin>", line 16, in <module> >>> pyodbc.ProgrammingError: ('42000', '[42000] [Actual][SQL Server] >>> Statement(s) could not be prepared. (8180) (SQLExecDirectW)') >>> >>> R. Mark Sharp, Ph.D. >>> [email protected] >>> >>> >>> >>> >>> On Jan 24, 2011, at 7:42 PM, Michael Bayer wrote: >>> >>>> cursor = conn.cursor() >>>> >>> >>> >>> -- >>> 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. >> >> >> -- >> 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. > > > -- > 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. -- 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.
