Hi, I configured James (2.0a2) to use a JDBC user repository (MS SQL server with the odbc driver). I found that I couldn't get a successful POP authentication. I tracked the issue down to ansi padding with both the username and password. Even when I unchecked the "use ansi padding etc.." in the odbc data source setup I was still getting the padding. So I dropped the user table, and then recreated the user table after "set ANSI_PADDING off" with sql server. Then I set ANSI_PADDING back on. This stopped MS SQL server padding and I was able to authenticate with POP.
Assuming I've correctly identified the issue I guess this should be built into sqlResources.xml. Hope this helps someone. cheers Linz -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
