Good catch. Added the quotes to the SELECT.
That example doesn't need quotes for the connect. However, in selecting a value, it needs to be valid. In this case, the original question has this code executing:
select log.txt, myid, myname, mychar from dbo.MyTable;
Unless there's a column named log.txt, this is invalid. I've added quotes tot the SELECT. In the example you show, there isn't a need for quotes in the first variable, and neither part of the :connect line needs quotes.