R&R ver 10.1.003 and MyODBC,MYSQL

[Jose_R_Gonzalez_(Guest)]

Hi:__ I have not been able to find out if R&R 10.1.003 can work with MyOdbc 3.51 and MySQL. I have tried everything I can think of and always get the same result. When asking for a result set, the dialgog that is presented just scans records without stopping. In print preview, pages are printed without stopping. No database related information is printed, only pageno, written text, etc.

[kfleming]

What data types are the fields in the report?____Kathleen__R&R Support

[Jose_R_Gonzalez_(Guest)]

Hi Kathleen:____ I use a blank report, user SQL, add a title and a page number. In the record band I add a numeric field, the row_id that MySQL uses for record number (int11), and a character field, the last name of an individual. The query is : "Select row_id, last from record for row_id <^30^". The result keeps counting records without stopping. The print preview also keeps counting pages. The title can be seen, as well as the page number. The row_id^s are all zeroes, and the last names are all blank. The table record has about 13,000 rows, and I let the search go on for well over 100,000 rows. It^s as if R&R is querying the database for something it cannot find.