OK, so I figured it out:

• make sure you know the architecture (32/64 bit) of the report server, as your connection has to have the same value.
• define the odbc connection on the report server AND also with the exact same name and properties locally on your laptop/desktop. This was my problem.