Here is a working example: <Realm name="IISRealm" className="org.apache.catalina.realm.JDBCRealm" debug="99" driverName="com.microsoft.jdbc.sqlserver.SQLServerDriver" connectionURL="jdbc:microsoft:sqlserver://xxx.mhsoftware.com:1433;DatabaseNa me=MyData;ProgramName=My Web Application;SelectMethod=cursor" connectionName="MyUser" connectionPassword="MyUser" userTable="vWebUsers" userNameCol="j_username" userCredCol="Password" userRoleTable="WebRoles" roleNameCol="role_name" />
The application select method on the connection URL is required. -----Original Message----- From: Søren Blidorf [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 25, 2003 5:36 AM To: [EMAIL PROTECTED] Subject: JDBC Realm & MS SQL 2000 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] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]