Does it report the name of the object that is invalid? We've seen some issues with multiple databases/schemas and I'm wondering if you're hitting something in that spectrum.
-- Jacques Nadeau CTO and Co-Founder, Dremio On Sun, Oct 25, 2015 at 2:04 PM, David Radford < [email protected]> wrote: > Hey everyone > > I'm trying to connect drill to a SQL server instance running on my machine. > I have downloaded the JDBC jar and placed it in the third party jar folder. > My plugin name is myplugin and the connection string looks like this > > { > "type": "jdbc", > "driver": "com.microsoft.sqlserver.jdbc.SQLServerDriver", > "url": "jdbc:sqlserver://localhost:1433;databaseName=Quotes;", > "username": "****", > "password": "****", > "enabled": true > } > > When I try and run a query from the command line like this > > select * from myplugin.Quotes.Application > > I get a SQLServerException saying that the object name is invalid. I have > verified that my user has access for selects on the table and have ran a > small java program to validate I receive results back >
