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
