New SQL Server + Enterprise 9

[fmrock]

Hey Everyone,

We have a CR Enterprise 9 server setup and all was working great until a week ago. About 50 of the reports on the server hit some production databases. Those systems were updated and moved from SQL server 2000 to 2005. I updated all 50 reports and all works well from Crystal on my personal computer.

Now the problem exisits when I reapplied these reports to the enterprise, they can not connect at all to these new database servers?

the reports do no uses and ODBC connection.

I have never had to setup anything for new database servers like this.

Any ideas or suggestions on where to look or anything to try.

Thanks for your help

 

[raja2008]

http://www.tek-tips.com/viewthread.cfm?qid=1475137&page=1

look in this thread may be you will find something you need.

And can you tell me how you handled the move to new database,did you change the datasource to each and everyone.

 

[fmrock]

After updating the MDAC on the server, the reports from the Enterprise started working.