That gun in the picture looks exotic but isn’t it a Walther Air Pistol?
I never knew that, but a little research says that it is:
“The famous pose of Sean Connery holding a gun across his chest had to be redone at the last minute. The Walther PPK was left at the studio, but the photographer had an old air pistol in his car. The gun in the picture is the air pistol.”
One website identifies it as a Walther LP53 air pistol.