Thanks for letting us all know the resolution, that may save some other poor soul from frustration....
Best Erick On Wed, Apr 29, 2009 at 9:31 AM, Ci-man <ciber...@yahoo.com> wrote: > > 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. > >