On 2011-10-19 11:31, Jeremy O'Sullivan wrote:
Hello, Regarding the ODBC error, I tried connecting to MonetDB using excel and got the same error as I got from OBI EE, see log below: Regards,
The problem is with the query which the MonetDB ODBC driver produces for the call to SQLTables where the catalog and schema names are both empty strings, the table name parameter is "%", and the table type parameter is "TABLE". Just as a FYI, the query that is produced is this: select cast(null as varchar(1)) as table_cat, s."name" as table_schem, t."name" as table_name, case when t."type" = 0 and t."system" = false and t."temporary" = 0 then cast('TABLE' as varchar(20)) when t."type" = 0 and t."system" = true and t."temporary" = 0 then cast('SYSTEM TABLE' as varchar(20)) when t."type" = 1 then cast('VIEW' as varchar(20)) when t."type" = 0 and t."system" = false and t."temporary" = 1 then cast('LOCAL TEMPORARY' as varchar(20)) else cast('INTERNAL TABLE TYPE' as varchar(20)) end as table_type, cast('' as varchar(1)) as remarks from sys."schemas" s, sys."tables" t where s."id" = t."schema_id" and t."name" like '%' and (1 = 0 or (t."type" = 0 and t."system" = false and t."temporary" = 0)) order by table_type, table_schem, table_name; The server doesn't like this query. :-( -- Sjoerd Mullender