Re: Using crystal reports with MySQL ADO connector

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Ah, why use Crystal Reports when the VS 2005 supports the RDL-based
ReportViewer control that's free, a lot easier to use and more heavily
documented? This control can accept a DataTable so you can use your MySQL
database as a Data Source to populate the DataTable. I wish you could get a
copy of my new book as it discusses this in detail.

The book will be available November 6th and I'm offering a substantial
discount off the online retail price for those that sign up on the support
site www.hitchhikerguides.net between now and when it's on the street.

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________

"Chukkalove" <someone@xxxxxxxxxxxxx> wrote in message
news:uCMHBsj4GHA.1196@xxxxxxxxxxxxxxxxxxxxxxx
I am a developer with limited database and zero crystal report experience.
I am very confused.

We wanted the ability to switch database providers easily, so I selected
to use ADO components with our application.
The database we're developing with is MySQL. I downloaded their MySQL
Connector/NET components which are ADO compliant. Using .NET connectors,
if we want to switch to another provider, there should be minimal code
changes necessary to make it run.
It all works fine so far. I connect to the remote database at run time
using a connection string read from stored configuration information.

Now I need to add reporting capabilities to the application, using Crystal
reports, and this is where Im confused.
http://support.businessobjects.com/communitycs/technicalpapers/rtm_reportingoffadonetdatasets.pdf
This example shows preparing data for use in a web project. Ours is a
desktop application.

So far I've tried to keep all of this as generic and configurable from
config files as possible.
The example in the above link uses a wizard to link to OLE DB provider
registered on the local pc. This immediately ruins the portability as it's
done through a wizard.
Is OLE DB the "same" as ADO?
Do I need to download and install OLE DB drivers from mySQL's site?
I wondered if once you've used this wizard, at later dates you can
programmatically change server information. Is that possible?

thanks :-)




.

Relevant Pages

  • Re: SYSTEMS ENGINEER/ VAX-VMS/ CAREER POSITION
    ... System Administration and database admin from NIIT, ... salary details and generate reports and enclosures,and calculates ... Responsibilities: ... Write New programs from user requirements, Programming Changes ...
    (comp.os.vms)
  • Re: Advice needed for a growing Access 2000 project
    ... However, it turned out that quite a few of those were "leftovers" from previous releases, no longer accessible from anywhere but the database window, and, thus, no longer used. ... But that certainly isn't the _norm_ -- without any 'heroic' measures, there are routine reports of split Access DBs ... Finally, in my opinion, for "Windows apps", that is, individual-user applications, modest-sized multiuser applications, and client-server applications of any size, Dot Net does NOT "help along" any of these issues. ... The post I reference was in reference its self to the MS Access Help file under "Microsoft Access database general specifications" ...
    (comp.databases.ms-access)
  • Re: running report cause fatal error- on Win98, not XP
    ... It is actually not that difficult to crash JET with complex queries, ... another query. ... only the more complex reports cause the crash- the others do ... Then compact the database: ...
    (microsoft.public.access.reports)
  • Re: running report cause fatal error- on Win98, not XP
    ... another query. ... only the more complex reports cause the crash- the others do ... Then compact the database: ... Still in the code window, choose Compile from the Debug menu. ...
    (microsoft.public.access.reports)
  • Re: SBS Monitoring Issues
    ... That kinda makes me wonder if either the master database is corrupt.. ... "Fred Orcutt" wrote in message ... >>Microsoft Small Business Server Support ... Reports are transmitted as configured but the content ...
    (microsoft.public.windows.server.sbs)