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]
