Crystal runs on desktop, "unable to connect" in CE
I'm ready to pull my hair out. I have several Crystal reports that I am trying to publish. They were actually created by a 3rd party vendor, but as thr vendor comes up with changes and corrections, they send the new reports to me and I then "repoint" them to our database, and publish them in CE. We have CE10, and all of the reports run fine on my desktop, but when after I publish them to CE and try to run them their, I get "Unable to connect: Incorrect Log On Parameters".
Some of these reports are changes to existing reports, and some are completely new. I have been working with these reports for over a year and have never had this problem. The existing reports run fine, but I am unable to publish any new ones. I have deleted and recreated my ODBC connection several times, and also the ODBC on the CE server, but no change. The database is SQL Server, not sure what other info would be relevant.
If anyone has any ideas, I sure would appreciate it.