DatabaseMetaData.getTables() returns empty result set if catalog contains dash

From: RogerB (anonymous_at_discussions.microsoft.com)
Date: 05/24/04 

Date: Mon, 24 May 2004 15:41:02 -0700

One of our customers are reporting an error when having a catalog (aka database name)
that includes a dash, ex: "my-db". If calling DatabaseMetaData.getTables("my-db", null, null, null)
it returns an empty ResultSet even though there are tables in the database.

Any ideas what may be wrong?

We're using:

Microsoft SQL Server
Microsoft SQL Server 2000 - 8.00.760 (Intel X86)
        Dec 17 2002 14:22:05
        Copyright (c) 1988-2003 Microsoft Corporation
        Enterprise Evaluation Edition on Windows NT 5.1 (Build 2600: Service Pack 1)
SQLServer
2.2.0037

Roger Bjärevall
Minq Software
http://www.dbvis.com