I always use a Datasource defined for computer.
Code:
DSN=MyDatasource;
UID=MyLogon;
Trusted_Connection=Yes;
APP=Microsoft Office 2013;
WSID=MyComputerName;
DATABASE=MySqlServerDB
All real connection info is defined in Datasource. When the server must be changed, I update the datasource, and this it all. I always can save a Registry Editor file to do this - and I can run the Registry Editor file on any computer to update identical datasources on various computers.