Martin,
In your original post you show both a DSN name value and a part of a DSN less connection string. This is a mixup and not the way it should be. DSN means stored in the Windows registry (user/system DSN) and then all the connection information is there. I pretty much always use the DSN less connection route.