Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Development Tools
 Other Development Tools
 getTables() returns empty result set if catalog contains dash

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2007-02-08 : 10:23:13
Sonia writes "Hello All,

This issue is related to MS SQL Server 2000 accessed through type 4 JDBC driver.


The gettables does not returns tables for database aka catalog name that have dash("-") in it. The information I got after googling was that, this is a DBMS issue and the stored procedure that gets invoked by the driver to get the tables is wrong.

Can anyone point me to the stored procedure that is getting invoked on gettables or any workaround for this problem.

any help is appreciated.

- Sonia"

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2007-02-08 : 10:29:29
use []

example
[table-name-with-dash]


KH

Go to Top of Page
   

- Advertisement -