The errors imply that it isn't connecting to your Database properly, or that you have a products table in your database already with different column names than the preset.
Are you able to view the columns in your database when creating a recordset? I'd start by making sure your connection works and that you are able to see your database columns in the recordset dialog.
The preview may just be a symptom of the first issue. I'd get that fixed first and see if that fixes the preview.