On 8/13/07, Christophe de VIENNE <[EMAIL PROTECTED]> wrote:
> I have checked out the trunk and am trying to run the unittests under
> linux using pyodbc.
> So far, the connection to the database is working, although I had to
> name the freetds odbc driver "{SQL Server}", including the {}, so the
> driver manager nows which one to use.
>
> My problem is the following, and I have to idea where it comes from :
> Any test from engine/bind fail with the following error (only the
> query changes) :
>
> DBAPIError: (ProgrammingError) ('42000', "[42000] [FreeTDS][SQL
> Server]Could not find stored procedure 'S'. (2812); [42000]
> [FreeTDS][SQL Server]Could not find stored procedure 'S'. (2812)")
> 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] \nFROM [INFORMATION_SCHEMA].[COLUMNS] AS
> [COLUMNS_1] \nWHERE [COLUMNS_1].[TABLE_NAME] = ? AND
> [COLUMNS_1].[TABLE_SCHEMA] = ?' ['test_table', 'dbo']
>
>
> Any hint ?I don't know the mssql parts of SA, but it looks like somewhere the statement is being treated as a collection (statment[0] or similar) so only the 'S' from 'SELECT...' is being executed. 'Could not find stored procedure 'S'.' is exactly the error ms-sql gives if one executes a statment with just an 'S'. Arnar --~--~---------~--~----~------------~-------~--~----~ 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 [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~----------~----~----~----~------~----~------~--~---
