The problem was not with Zope. What I failed to do was to add the server as a dsn in Control Panel --> Administrative Tools --> Data Sources (ODBC). After doing that and everything that roberth did, the connection installed perfectly.