Found the problem. It is with Microsoft jdbc drivers (jdbc 2.0). With the latest download Microsoft provides two .jar files: sqljdbc.jar sqljdbc4.jar
I had copied both into the lib directory. By doing so it used the older drivers (sqljdbc.jar) which do not work with jvm1.6. You get this kind of cryptic message in debug trace: The JDBC Driver version 2.0 does not support JRE 1.4. You must upgrade JRE 1.4 to JRE 5.0 or later when using the JDBC Driver version 2.0. In some cases, you might need to recompile your application because it might not be compatible with JDK 5.0 or later. For more information, see the documentation on Sun Microsystems Web site No further help from MS or boards. I experimented and removed the sqljdbc.jar file from lib directory so that only the sqljdbc4.jar is available. And bingo. Everything is working like a charm. Thanks everyone, -Ci -- View this message in context: http://www.nabble.com/Unable-to-import-data-from-database-tp23283852p23295866.html Sent from the Solr - User mailing list archive at Nabble.com.
