Win a copy of Learn Spring Security (video course) this week in the Spring forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

getCatalogs() method in DatabaseMetaData

 
Amrit Tiwana
Greenhorn
Posts: 24
  • 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: 34071
331
Eclipse IDE Java VI Editor
  • 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
  • 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