Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I'm troubleshooting an issue with importing data to Apache Solr from a MS SQL Server database via a JDBC connection. Solr is hosted on a CentOS linux machine, and SQL Server is (of course) on a seperate Windows Server box.

I can see the login attempt on SQL Server, but it stops at a single Audit Login event, and Solr never completes the query, and never throws an exception. The same SQL user works fine when connecting directly; leading me to suspect either a network issue or (possibly) a SQL configuration issue. What's more, the production Solr box successfully queries the QA database.

What basic CLI utility can I run from the Solr/Linux box to connect to SQL Server, using the same JDBC driver and parameters, to test if I'm able to perform basic SQL queries?

share|improve this question

1 Answer 1

I would use Squirrel SQL or DBVis both are Java based and need a JDBC driver, so you can use the same one. Great tools.

share|improve this answer
1  
Thanks! I forgot to specify that this is a command-line only server, but I'll see if by chance I can run it remotely over xming –  STW Dec 16 '11 at 14:23

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.