Thanks for your reply.

Unfortunately, I get another error:

Msg 7350, Level 16, State 2, Line 1

Cannot get the column information from OLE DB provider "MSDASQL" for linked server 'MYSQL'.

Could it be a permissions issue from the website's MySQL setup?