I just bought xmod pro and I am trying to figure out how to use an SQL database (on the same host) other than the DNN database for my forms. It doesn't appear to be obvious how to do this. Can someone please point me in the right direction.

Use the "ConnectionString" property of the <SubmitCommand> and/or <SelectCommand> tags (for forms) and the <ListDataSource>, <DetailDataSource>, and <DeleteCommand> tags (for templates).