View Not Visible

Legacy Poster

• 2014年11月14日 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 ★

  • 2014年11月14日 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

サインインしてコメントを残してください。