View Not Visible

Legacy Poster

• November 14, 2014 15:04

I created a View in MS SQL Server 2008 R2 and it is not visible in Bartender. When I attempt to add it manually via "Enter Table Names by Hand Only," it returns Bartender Error Message #6669, "table_view" is not a valid table name for the named OLE DB Data Source currently in use.

 

I am able to see the view perfectly fine in Crystal Reports and SQL Explorer. Bartender seems to be missing it.

 

Any ideas?

0

• 

  Legacy Poster

  ★ BarTender Hero ★

  • November 14, 2014 15:22

  I had to grant db_datareader to my label viewer user in SQL Server Management Console.

   

  Able to see the view now!

  0

Please sign in to leave a comment.