I got the latest jar file from the MS website and then changed the authentication to Mixed Mode on my DB. That seems to have fixed it. My 2005 Server was Windows Authentication only and that worked so there are obviously quite a few differences between the versions of the DB. I learn something new every day!!!!
Thanks for the feedback! Adam On Tue, Jan 4, 2011 at 10:20 PM, Lance Norskog <goks...@gmail.com> wrote: > Do you get a new JDBC driver jar with 2008? Look around the > distribution or the MS web site. > > On Tue, Jan 4, 2011 at 7:06 PM, pankaj bhatt <panbh...@gmail.com> wrote: > > Hi Adam, > > Can you try by downgrading your Java version to java 5. > > However i am using Java 6u13 with sqljdbc4.jar , i however do not > > get any error. > > If possible, can you pleease also try with some other version of > > Java 6. > > > > / Pankaj Bhatt. > > > > On Wed, Jan 5, 2011 at 5:01 AM, Adam Estrada > > <estrada.adam.gro...@gmail.com>wrote: > > > >> Can anyone help me with the following error. I upgraded my database to > SQL > >> Server 2008 SP2 and now I get the following error. It was working with > SQL > >> Server 2005. > >> > >> <Solr Error Stack> > >> Caused by: java.lang.UnsupportedOperationException: Java Runtime > >> Environment > >> (JR > >> E) version 1.6 is not supported by this driver. Use the sqljdbc4.jar > class > >> libra > >> ry, which provides support for JDBC 4.0. > >> > >> Any tips on this would be great! > >> > >> Thanks, > >> Adam > >> > > > > > > -- > Lance Norskog > goks...@gmail.com >
