Windows allows, both a system and a user DSN with the same name (stupid). Since I could only create a SQL database connection (DSN) and don't have an actual server wasn't able to verify what takes preference.
Wine has no concept of security, if we write to the SYSTEM vs USER isn't an issue. However, the application I was testing, has a service which connects to the a SYSTEM DSN and expects to writes back to that location.