Is this an app you imported straight from Desktop to Server ? If it is, did you remember to create the connection object in the App again ? Although your coded references to the connection remain, the actual connection is lost. Anyway I presume you did this.
Next, does the server actually have the ODBC Driver manager added ? Are you connecting to SQLServer ? In which case a OLEDB connection may serve you better.