Also when I enter valid credentials it just keeps prompting me again and again.
-----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Rod Harris Sent: Thursday, March 11, 2010 12:45 AM To: arslist@ARSLIST.ORG Subject: Re: Help Please - Crystal 10 problem Hi Brian, Make sure that your mid tier web reporting is configured to use the DSN that is in your reports. I have found that if a report uses a datasource other than the one defined in the mid-tier web reporting settings you will be prompted for a password. It will work however once you do that. If the reports aren't working at all then you may have deeper problems. Try running the report directly from the web reporting server. This may alert you to any errors you are getting. Trying to open a report in the mid tier will create a copy of the report in the windows temp directory. Try running that and seeing what's wrong with it. I don't tend to name my datasource the default "AR System ODBC Data Source". Its easier to discriminate from the default install if you give it a different name. You want to make sure that your reports use the system data source that you have set up for the purpose. Rod On 11 March 2010 02:35, Sokol, Brian <bso...@scholastic.com> wrote: > ** > 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:arsl...@arslist.org] On Behalf Of Grooms, Frederick W > Sent: Wednesday, March 10, 2010 1:11 PM > To: arslist@ARSLIST.ORG > Subject: Re: Help Please - Crystal 10 problem > > ** > > Is your DSN a System or User? > > > > From: Action Request System discussion list(ARSList) > [mailto:arsl...@arslist.org] On Behalf Of Sokol, Brian > Sent: Wednesday, March 10, 2010 11:19 AM > To: arslist@ARSLIST.ORG > 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:arsl...@arslist.org] On Behalf Of Hunter, Justin (West > Chester) > Sent: Wednesday, March 10, 2010 12:07 PM > To: arslist@ARSLIST.ORG > 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" <bso...@scholastic.com> 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:arsl...@arslist.org] On Behalf Of Hunter, Justin (West > Chester) > Sent: Wednesday, March 10, 2010 11:29 AM > To: arslist@ARSLIST.ORG > 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" <bso...@scholastic.com> 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: rmisoluti...@verizon.net ARSlist: "Where the > Answers Are"_ _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: > "Where the Answers Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
