Skip to Content
author's profile photo Former Member
Former Member

ADO.NET Datasource, getting Logon Failed

I have worked my way through the samples and walk-throughs in the blogs and help docs on this site to create a report that is based on an ADO.NET Dataset (XML xsd file).

My actual data dataset is generated from a STored procedure and a command/adapter object. I then set the SetDataSOurce of the report to the dataset created from the stored procedure.

My DB is MySQL

Every time I set the reportsource of the viewer to my report document and view the report it says login failed.

Why?

My XSD is just created by hand, no DB connections. It has just 2 fields, login name and last login date. Fields are named exactly as in the DB. In fact if I comment out the line that does 'SetDataSource' for the report and just show the report with no data, just as it comes, it still says Login Failed.

What is happening? Why is it wanting to login to show a report that has no data other than what is defined in the xdd, which is nothing. There is no data attached to the report in design time. If I preview I just get a list of VB colours which I guess is some kind of design time placeholder.

I just dont know what is going on but this is putting a major project in jeopardy. I have 5 working days to get this working and deliver 20 reports. Otherwise my Customer will cancel. I moved to Crystal from a competitors product thinking it would be easier and faster. I hope I didnt make a big mistake..

Please can someone help me get this working so I can get going on my report designs and deliver this project

Thanks

Mark

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Best Answer
    Posted on Aug 27, 2013 at 07:52 PM

    Mark, please see this blog re. my troubleshooting suggestions for this issue.

    - Ludek

    Senior Support Engineer AGS Product Support, Global Support Center Canada

    Follow us on Twitter

    Got Enhancement ideas? Try the SAP Idea Place

    Share Your Knowledge in SCN Topic Spaces

    Add a comment
    10|10000 characters needed characters exceeded

    • Problem is, you essentially told the report engine to look at the dataset, then you told it, never mind - here is an actual database connection. So the report engine is not using the dataset. You can test this by providing an incorrect logon at SetDatabaseLogon...

      I suspect you'll get a databse log on error, or a prompt.

      - Ludek

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.