"I choose Remote server and Testing server"
My question was geared more towards how the testing server settings are configured. is it configured to use a local server with wampp or xampp installed, or is it connecting to your remote host.
You say the error happens when testing the recordset, what is the structure of the table?
it may be one of the column names causing the problem.