So, correct if i´m wrong. To connect to you database is:

 Class.forName( "sun.jdbc.odbc.JdbcOdbcDriver" );

 Connection dbConn = DriverManager.getConnection( "jdbc:odbc:afec",
"UserName", "UserPassword" );

> ----------
> De:  Chaikin, Yaakov Y (US SSA)[SMTP:yaakov.y.chaikin@(protected)]
> Responder:  Tomcat Users List
> Enviada:  sexta-feira, 5 de dezembro de 2003 14:17
> Para:  Tomcat Users List
> Assunto:  RE: Database pool problem
>
> >  Could you show us how you make a simple connection to that M$
> Acess
> > database to compare?
>
> Well, I sort of already did. The realm is working 100% using that
> database. Here is my <Realm> tag:
>
> <Realm
>   className="org.apache.catalina.realm.JDBCRealm"
>  connectionName="default"
>  connectionPassword="afecrelease2003"
>  connectionURL="jdbc:odbc:afec" debug="0"
>  driverName="sun.jdbc.odbc.JdbcOdbcDriver"
>  roleNameCol="UserRole"
>  userCredCol="UserPassword"
>  userNameCol="UserName"
>  userRoleTable="TestUsers"
>  userTable="TestUsers" validate="true"/>
>
> This works and it's the same attributes, just with different names to
> comply with Realm tag dtd.
>
> Any ideas?
>
> Thanks,
> Yaakov.
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: tomcat-user-unsubscribe@(protected)
> For additional commands, e-mail: tomcat-user-help@(protected)
>