Solved

Crystal connection issues with a dataset provided by a dll

Posted on 2007-04-10
3
608 Views
Last Modified: 2011-09-20
Hello,
I'm consuming a web service with in a dll that has a public function that returns a dataset.
I'm trying to connect to it with Crystal Crystal reports. I'm pretty sure the "Double Hop" rule while passing my credentials is causing me grief even though I'm supplying a NetworkCredential. If I reference the dll in a test project it brings back the data, but when I try to connect to it with Crystal I get "logon failed  Details:mscorlib : Exception has been thrown by the target of an invocation.
Any ideas on how to get a around this would be appreciated.

Here is my class from within the dll:
public class cEntry
    {
        private EntryWrapper.entry.Service1  t = new EntryWrapper.entry.Service1();
        DataSet relational_data;

        public DataSet tickets()
        {
            string u = ConfigurationManager.AppSettings["user"];
            string p = ConfigurationManager.AppSettings["pass"];
            string d = ConfigurationManager.AppSettings["domain"];
            t.Credentials = new System.Net.NetworkCredential(u, p, d);//Send credentials
            string strWeb = t.ReportTest("F241A905-89B1-416d-8DC2-8C2EA1A6B434", ""); //Get xml string from Entry

            XmlDocument doc = new XmlDocument();
            string inputXml = strWeb;
            doc.LoadXml(inputXml);
           
            XslCompiledTransform xslTransform = new XslCompiledTransform(false);
            xslTransform.Load(XmlReader.Create(new StringReader(Resource.ticket))); //Load xlst string to the transform object
            StringBuilder result = new StringBuilder();
            XmlWriter output = XmlWriter.Create(result);
            xslTransform.Transform(doc, output); //Apply xlst to the xml file
            XmlTextReader xml_reader = new XmlTextReader(new StringReader(result.ToString())); //read the file and convet to xml

            relational_data = new DataSet();
         
            relational_data.ReadXml(xml_reader);
            return relational_data;
        }

0
Comment
Question by:ChadMarsh
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 17

Accepted Solution

by:
MIKE earned 500 total points
ID: 18902983
I'm "shooting from the hip" here..but .....do you have Crystal Loaded onto this SERVER where the data is located? Where you are running this command?

MikeV
0
 
LVL 2

Author Comment

by:ChadMarsh
ID: 18904712
Hi There, Thanks for posting. I was beginning to think that nobody want to touch this one.
Crystal is on the same server. Actually that server has the Business View Manager, Crystal Report Server and Crystal Developer.  They run on a separate drive though.  I has Crystal on the phone yesterday and they seemed to be scratching their head over it.  The data that I'm pulling is from a proprietary database that Team Headquarters Entry uses. It's all XML based so the web service was the easiest way to get the data. I went one step further and bypassed the webservice and queried the data directly from the dll. Same error, unfortunately.  I re-opened my ticket with Crystal.  
The other strange thing that the Crystal support rep had be do was connect to my local copy of the dll and create a report. That worked. Then switch the datasource to the network copy of the dll. That worked. The only problem is when you save the report and exit, you get the error when you try to open it again.
Chad
0
 
LVL 2

Author Comment

by:ChadMarsh
ID: 18918729
Well, I ended up writing a script component in an SSIS. I'm just going to put the data into SQL and report off of that. Thanks for the reply though
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
CSS for Popup in ASP.NET 4 43
Building an object from several other objects 4 36
asp.net repeater server posting 5 35
Getting Maximum Score for certain records 7 23
Problem Hi all,    While many today have fast Internet connection, there are many still who do not, or are connecting through devices with a slower connect, so light web pages and fast load times are still popular.    If your ASP.NET page …
Exception Handling is in the core of any application that is able to dignify its name. In this article, I'll guide you through the process of writing a DRY (Don't Repeat Yourself) Exception Handling mechanism, using Aspect Oriented Programming.
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

738 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question