Data Reports And Mysql

[robertx]

I have a database application using VB6 and MySQL as the back end.

I have reports using VB's data reports. The reports generate OK except that every time I run a report, the system generates a dialogue box which requests connection parameters, DSN name etc. Entering any text in the DSN name field enables the OK button and displays the report.

How do I stop the dialogue from appearing? It does not appear when I connect to an Access database.

[parksie]

How about a DSN-less connection? That worked okay for me and I don't think it ever popped up a box.

What method of connection are you using?

[robertx]

I am connecting to MySQL using a connection string to my local PWS server.

What are DSN and DSN-less connections all about?

[parksie]

ADO or DAO?

With ADO a DSN-less connection is where you use a full connection string with no DSN defined.

[robertx]

I am using ADO with a full connection string as per your attachment which I downloaded some time ago.

[parksie]

Oh. It never prompted me on mine

Nobody else ever bothers answering MySQL questions round here so it's always me...unfortunately not having VB installed is a bit of a problem

I'll find my CD and dig around a bit...will mess around with the OLEDB stuff and basically bugger it all up...hopefully I'll find something useful for you

[parksie]

Ok - this is what I'm using:

VB5 no SP
ADO 2.5
MySQL 3.23.29
MyODBC 2.50.36

That works perfectly (just tested it again).

[bisdave]

I don't know how to connect MySQL with DataReport. If anyone know how to do it please show me step by step ..... Thank You very much.

I've try it, but it now allow me to define the parameters, so I don't know how to do it.

You can post reply here or mail your step(or souce code) to my e-mail: [email protected].....