I'm using a simple SELECT statement, that already works for another solution, but for some reason I get this statement -

========================================
Incorrect syntax near the keyword 'user'
=========================================

This is the sql statment -
----------------------------------------------------------------------
string sSQL = "SELECT userId FROM user WHERE username=@username AND userPasword=@Password";

SqlCommand cCommand = new SqlCommand();
cCommand.CommandText = sSQL;

cCommand.Parameters.Add("@username", SqlDbType.VarChar).Value= pUsername;
cCommand.Parameters.Add("@userPassword", sqlDbType.VarChar).Value = pPassword;
------------------------------------------------------------------------

mysql has its own user table, try renaming your user table

That was the problem. The other table was called users. Thanks for the tip