I just dnload your product 2 days ago and testing it. Very good product.
I've found this problem in "update password" function:
It seems not to recognize that square brakets already exists in table name and doubles them...
Error in Query Construction
update set [Pwd] = @Password
where [UID] = @Login and [Pwd] = @OldPassword
Extract of WEB.CONFIG with table name definition.
<?xml version="1.0"?>
<!--
Note: As an alternative to hand editing this file you can use the
web admin tool to configure settings for your application. Use
the Website->Asp.Net Configuration option in Visual Studio.
A full list of settings and comments can be found in
machine.config.comments usually located in
\Windows\Microsoft.Net\Framework\v2.x\Config
-->
<configuration>
<configSections>
<section name="SubSonicService" type="SubSonic.SubSonicSection, SubSonic" requirePermission="false"/>
</configSections>
<appSettings>
<add key="LoginMethod" value="WITHLOGIN" />
<add key="LoginFrom" value="DB" />
<add key="UserListTable" value="[dbo].[USERS]" />
<add key="FieldUserLogin" value="UID" />
<add key="FieldUserLoginType" value="String" />
<add key="FieldUserPwd" value="Pwd" />
<add key="FieldUserPwdType" value="String" />
<add key="FieldUserEmail" value="UID" />
<add key="FieldUserEmailType" value="String" />
<add key="MailSender" value="clfreddi@tin.it" />
any suggestion ?
Best Regards
Claudio