Validate Credentials Against User Record in Database

[weirddemon]

Isn't 'User' a reserved word in some DBMSs? Try a completely different name.

If you're using 'User' as the table name then you'll probably have to escape it, i.e. use '[User]' in your SQL code.

Right. That makes sense.

However, when I change the table to any other name, and reference it appropriately, I get the original error.

Is there any other things I should have done when setting up the database or table?

One thing I thought was strange, was the SQL databases I could create from the wizard.

When I choose a new data source, I had two options:

Microsoft SQL Server and
Microsoft SQL Server Database File

I chose the latter as it seemed more appropriate.

That wouldn't affect this at all, right?