[MonetDB-users] ODBC connection issues

Sjoerd Mullender sjoerd at acm.org
Wed Oct 19 15:22:51 CEST 2011


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

-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 371 bytes
Desc: OpenPGP digital signature
URL: <http://www.monetdb.org/pipermail/users-list/attachments/20111019/d5929423/attachment.sig>


More information about the users-list mailing list