I believe that your SQL should not have a terminating “;”.

That character is used to signify the end of a line/command/etc., but .CommandText will know where the line ends, and so the ‘;’ is unnecessary. (Anything unnecessary usually causes an error...)

[BTW: This question should probably be in Beginning VB.NET... Just a thought.]