Nevermind. I had to add the ODBC link on the webserver.