Print Page | Close Window

When I click on the View tab in the Object Mapper it doesn’t show me the available views

Printed From: IdeaBlade
Category: DevForce
Forum Name: DevForce Classic
Forum Discription: For .NET 2.0
URL: http://www.ideablade.com/forum/forum_posts.asp?TID=163
Printed Date: 23-Jan-2026 at 10:37pm


Topic: When I click on the View tab in the Object Mapper it doesn’t show me the available views
Posted By: Customer
Subject: When I click on the View tab in the Object Mapper it doesn’t show me the available views
Date Posted: 12-Jul-2007 at 12:42pm

I was trying out Ideablade’s Object Mapper in one of my projects. I was trying to use a View as a data source but for some reason when I click on the View tab in the Object Mapper it doesn’t show me the available views stored on the SQL Server.

The SQL Server I’m using is SQL Server 2000 with Service Pack 3 installed. Is there something that I need to do on the SQL Server for the views to show up on the Object Mapper or are there some special statements I need to include in my view declaration so the Object Mapper would recognize it?


Replies:
Posted By: IdeaBlade
Date Posted: 12-Jul-2007 at 12:43pm
I've seen this problem exactly once before from another customer.  The most likely  explanation is that the user account that you are using to develop your application doesn't have the appropriate access rights ton the views.  Try running as admin.
 
Hope this helps.  If it doesn't ,let me know.

Posted By: Customer
Date Posted: 16-Jul-2007 at 11:17pm
I am another customer, and I found this post on the subject:

But the SQL account I’m using is already a sysadmin and dbo.

We verified that the SQL security is correct by setting up an ODBC connection using the standard SQL Server driver. We linked to the View in question through Access 2003 using the same SQL account and password as used in the Object Mapper and it works fine.

.

Posted By: IdeaBlade
Date Posted: 16-Jul-2007 at 11:19pm
Could you send me the database? 

Posted By: Customer
Date Posted: 16-Jul-2007 at 11:20pm

We got past the problem for now. We changed the Max Display # to 200 (from 100) and Refreshed to get the one available View to show up.

Posted By: IdeaBlade
Date Posted: 16-Jul-2007 at 11:22pm

Thanks for finding this.  I’ll update the forum with this information so that the next user who runs into this problem will have the benefit of your experience.


Print Page | Close Window