Problem with DataReport and Mysql Database

[corneagigi]

Hy

I am building an application that is using an mysql database and I am trying to build Datareports using ADO data control.
My problem is that in the reports it puts me only the first record from the database for "Number of records" times, so I can't see all the records I need.

My code looks like this:


With DR
Set .DataSource = rs

.Sections("section1").Controls.Item("Txt0").DataField = rs.Fields(0).Name
.Sections("section1").Controls.Item("Txt1").DataField = rs.Fields(1).Name
.Sections("section1").Controls.Item("Txt2").DataField = rs.Fields(2).Name
.Refresh
End with

Waiting for your response.
Thanks