File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

getCatalogs() method in DatabaseMetaData

 
Amrit Tiwana
Greenhorn
Posts: 24
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,

I'm using getCatalogs() method in DatabaseMetaData to get listing of all catalogs(database) in SQL Server 2000. I've created a DSN say 'demo'. When I create DSN, it shows me all the databases. But when I make call using getCatalogs() method in DatabaseMetaData, it doesn't return 'model' database. The others i get i.e. master, msdb, Northwind, pubs, tempdb.
Does anybody why???

Thanks
 
Jeanne Boyarsky
author & internet detective
Marshal
Posts: 33691
316
Eclipse IDE Java VI Editor
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Amrit,
What is the relationship between "model" and "demo"? I'm not sure if I'm following the question.

Off the top of my head, you may want to check that the new database has the appropriate permissions.
 
Amrit Tiwana
Greenhorn
Posts: 24
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
'demo' is the DSN name which I've created.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic