Connery commonly wears MacLean of Duart Hunting which is his Scottish family lineage. Although Connery is also an Irish name, it has its ties in Scotland as well and falls under the order of a sept. He wore his family tartan, MacLean of Duart for his presence to the Queen when he was knighted, which is where you would wear your Clan...although you can wear any tartan, and he does. He also often wears generic non clan tartans, such as Flower of Scotland, Scotland the Brave and an assortment of district tartans.
I offer this information as someone who is a kiltmaker, A Scot, and an importer of Scottish tartan. And, not a correction in any way ill meant, but Scotch is a drink or a broth...otherwise it is a Scottish or Scots tartan :) ...and you are right to doubt the Irish district tartan.. I have never, ever seen him in an Irish tartan.,,have a lovely day :)