It is a system DSN. The only thing that changed is I uninstalled the Remedy User client. I reinstalled it but now the report from the Mid Tier it will not run. If I run the report from the remedy client it does run. I can not find anything wrong. Brian
________________________________ From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Grooms, Frederick W Sent: Wednesday, March 10, 2010 1:11 PM To: [email protected] Subject: Re: Help Please - Crystal 10 problem ** Is your DSN a System or User? From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Sokol, Brian Sent: Wednesday, March 10, 2010 11:19 AM To: [email protected] Subject: Re: Help Please - Crystal 10 problem ** It lists this: Data Source Name: AR System ODBC Data Source This is the same DSN I have on my Mid Tier. ________________________________ From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Hunter, Justin (West Chester) Sent: Wednesday, March 10, 2010 12:07 PM To: [email protected] Subject: Re: Help Please - Crystal 10 problem ** If you open up an existing report under the Database menu you find set datasource location. It will list the DSN you created the report with. On 3/10/10 11:41 AM, "Sokol, Brian" <[email protected]> wrote: ** How do I check what it was and how do I change it to work again? ________________________________ From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Hunter, Justin (West Chester) Sent: Wednesday, March 10, 2010 11:29 AM To: [email protected] Subject: Re: Help Please - Crystal 10 problem ** We had the same problem and it turned out to be that when the ODBC client was reinstalled it was created with a different Data Source Name than what all of the reports were built using. Once we renamed the Data Source and provided the reporting UID, all the reports started working again. On 3/10/10 11:20 AM, "Sokol, Brian" <[email protected]> wrote: ** I am using Crystal 10 to run reports. I have it installed on my Mid Tier server. I foolishly uninstalled the AR User client on the server which must have removed the ODBC connector. This broke all my reports. I then reinstalled AR User and configured the ODBC settings. Now whenever I try to run a report a log in box pops up asking for credentials to connect to my Mid Tier server? Even if I put in my own ID and password it does not go away. Can anyone help please? Keep in mind this is Crystal 10 . Thanks Brian Sokol Manager, Desktop Services Scholastic Inc. 557 Broadway NY, NY 10012 (212) 343-6494 http://www.Scholastic.com <http://www.scholastic.com/> _Platinum Sponsor: [email protected] ARSlist: "Where the Answers Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
