I suspect that either the service account does not have the same permissions as the user account that you used to develop the document, or you are using a DSN connection that does not exist on the server, or you developed with a 32 bit connection and the server is defaulting to a 64 bit version, or the drivers for he relevant version do not exist on the server.
If it is a DSN connection, you need to have admin rights on the server and run odbcad32.exe to create the DSN on the server. The 64 bit version (if you are using 64 bit Windows) is usually in C:\Windows\System32. The 32 bit version is usually in C:\Windows\SysWow64 (that is the right way round!).
You can also confirm the existence of ODBC drivers using odbcad32.