None. I am being refered to my loginerror page. I forgot to write that I am not sure what to write in the Realm. Sorry.
<Context path="/web" docBase="c:/projects/web/web" debug="0" reloadable="true"> <Realm className="org.apache.catalina.realm.JDBCRealm" debug="0" connectionName="username" connectionPassword="password" driverName="sun.jdbc.odbc.JdbcOdbcDriver" connectionURL="jdbc:odbc:web" userTable="users" userNameCol="username" userCredCol="password" userRoleTable="user_roles" roleNameCol="rolename" /> </Context> I normally write "db".."tablename", so do I write "db".users? or just users Either way it just returns to my errorpage -----Oprindelig meddelelse----- Fra: Ian Hunter [mailto:[EMAIL PROTECTED] Sendt: 25. februar 2003 14:27 Til: Tomcat Users List Emne: Re: JDBC Realm & MS SQL 2000 What Exception do you get? ----- Original Message ----- From: "Søren Blidorf" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, February 25, 2003 7:51 AM Subject: VS: JDBC Realm & MS SQL 2000 This is how I set it up for Access. When I change the driver settings to Oracle or MySQL it works just fine. The connection to the SQL server works just fine. It is only the realm that does not work. I am not sure what else to send!!! <Context path="/web" docBase="c:/projects/web/web" debug="0" reloadable="true"> <Realm className="org.apache.catalina.realm.JDBCRealm" debug="0" connectionName="username" connectionPassword="password" driverName="sun.jdbc.odbc.JdbcOdbcDriver" connectionURL="jdbc:odbc:web" userTable="users" userNameCol="username" userCredCol="password" userRoleTable="user_roles" roleNameCol="rolename" /> </Context> -----Oprindelig meddelelse----- Fra: Xavier Prélat [mailto:[EMAIL PROTECTED] Sendt: 25. februar 2003 13:44 Til: Tomcat Users List Emne: Re: JDBC Realm & MS SQL 2000 Søren Blidorf wrote: >Hi. >I am trying to create a realm login. > >When I use a mysql, MS Access or Oracle DB it works just fine. But when >I try with MS SQL 2000 server it just does not work. > >Can anybody tell me why? > >Søren Blidorf > >Nolas Consulting >Gustav Wiedsvej 9 >DK-2860 Søborg > > >Telefon: +45 39676513 >Direkte: +45 61676513 >Web: www.nolas.dk > > > > >--------------------------------------------------------------------- >To unsubscribe, e-mail: [EMAIL PROTECTED] >For additional commands, e-mail: [EMAIL PROTECTED] > > > > > > Can you tell us more about "it just does not work"... what is your conf, properties...etc... Xavier --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]