RE: Tomcat 6, SQL Server 2005 JDBC Realm not working

2007-06-14 Thread Propes, Barry L
so in one connection string you have user and in the Realm you're using userName? -Original Message- From: Richard Sayre [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 13, 2007 12:42 PM To: users@tomcat.apache.org Subject: Tomcat 6, SQL Server 2005 JDBC Realm not working I have

Re: Tomcat 6, SQL Server 2005 JDBC Realm not working

2007-06-14 Thread Richard Sayre
It turns out I had to RTFM. "Quick Start: 3. Place a copy of the JDBC driver you will be using inside the $CATALINA_HOME/lib directory. Note that only JAR files are recognized!" I only had it in my Web App lib folder On 6/14/07, Richard Sayre <[EMAIL PROTECTED]> wrote: I just tried the exac

Re: Tomcat 6, SQL Server 2005 JDBC Realm not working

2007-06-14 Thread Richard Sayre
I just tried the exact same thing with the jTDS driver and I got the same error: 14-Jun-2007 10:49:02 AM org.apache.catalina.realm.JDBCRealm authenticate SEVERE: Exception performing authentication java.sql.SQLException: net.sourceforge.jtds.jdbc.Driver at org.apache.catalina.realm.JDBC

Tomcat 6, SQL Server 2005 JDBC Realm not working

2007-06-13 Thread Richard Sayre
I have a web app that connects to my SQL Server 2005 Database with no trouble using this code: Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver"); con = DriverManager.getConnection("jdbc:sqlserver://server-2006;databaseName=v362;user=user;password=dbase"); My application r