I am creating an ODBC connection to a SQL Server 2008 db for reading purposes only
The username is set as a SQL user and can open views via SQL Server 2008 Management Studio
however I cannot list those views in my LEI ODBC connection. I can only see views owned by INFORMATION_SCHEMA and sys
I cannot see any dbo views (or tables for that matter)
If I manually enter my view e.g. dbo.vwTest, I get this message...
No data found. Either there were no columns found in the ODBC source provided or the metadata does not exist. Use automatic field mapping if creating the metadata
Any clues? Is this a permissions issue on SQL2008?