Ells (4/14/2015)
That's kind of where I was thinking the issue could be. However as the is is 32 bits and I am opening them on the server which is 32 bits my only last guess is that I am logged on as a different user to the user that runs the reports. So the data source works for sql agent but not for the account I am logged in as.Hope that makes some sense.
Cheers
E
Could be, depending on the authentication method used by the data source connections. It could also be the case that the DSN was created as a user-DSN, meaning that it will only be accessible to the user's profile who created it.