I have tried setting the ODBC as both a USER and SYSTEM DNS.  It seems to me that there must be a different way to configure the access to an ODBC...

Thanks for the reply the ODBC is installed on the new machine.   I have tested it as i can connect to the Attache Business Partner infomation via EXCEl.    The problem...

Check that report Caching is not enabled for that report.  I have have one instance where i had to delete the report and then re deploy the report to get...

Thanks it is working a great. 

i am adding the table to the article via the GUI.

thanks i dropped the subscription and removed teh stored proc from the articles and re subscribed and it seems fine..