Object mapper not showing Views in "Add Classes" dialog

 

Everything is working great, except that only one of these data sources allows me to add a new class based on a database view. The other three databases are showing an empty list. The tables and stored procedures are shown in the list for all 4 data sources - it is only the database Views that do not appear.

 

I am assuming that there is something amiss with my databases, but I cannot for the life of me figure out what is different between the one that works and the ones that do not. I imagine it is something to do with permissions or meta-data visibility, but I simply cannot get the database Views to display in the Add Classes dialog.

 

Has anyone ever seen this before?

 

Oh, and I'm using DevForce Classic 3.7.6.0.

 

Thanks,

 

Dan.

 

Since one database was allowing me to see views in the mapper, I simply created the view in that database as a trivial "select * from otherdatabase.view", added this new view to the mapper and saved the updated model.

 

Then I opened the .ORM file, changed the datasource to point to the correct database, saved it, re-opened the mapper and forced it to regenerate the model.

 

Finally, I deleted the temporary view in the database and everything appears to be working, so far.

 

The views are still not showing up in the Object Mapper, but at least the code generator doesn't seem to care, so I am able to create a class from the database view.