i cannot create report

[iamresearcher]

Hi I am new to crystal report

I use mysql for database

so I try to create new report using report wizard and go to create new connection to connect to database and I dont know where to go next from here to connect to mysql database. please help

[iamresearcher]

help guys. I am using mysql odbc 5.1 driver.

[iamresearcher]

help guys. I am using mysql odbc 5.1 driver and crystal reports 9

[iamresearcher]

I have tested using crystal reports 8.5 and I can see setup database and tables in odbc but when I use crystal reports 9.22, I can connection to database but there are no tables. why? what is the problem. I want to use version 9.22.

[jggtz]

Try using an ODBC and then in CR use OLE DB ADO / ODBC to connect to db with the created DSN

[iamresearcher]

i created an odbc and use ole db ado / odbc but I use mysql odbc 5.1 from which there is no mysql odbc driver on the list of ole db providers on CR.

[jggtz]

You need to install the mysql driver 5.1 in your pc
http://dev.mysql.com/downloads/connector/odbc/

[iamresearcher]

i have already install that driver but it did not solved the prob.

[jggtz]

If you already created the DSN then you'll see the name of the DSN you created in CR
menu / New / Using the report wizard / Create New connection / Ole DB ADO / Microsoft OLE DB Provider for ODBC Drivers / your DSN name

[iamresearcher]

yes i can see that but I cannot continue to connect with it because of connection error possibly because I created the dns with mysql driver and I am connecting now with microsoft ole db driver

[jggtz]

Well, now try with ODBC (RDO) / your DSN

[iamresearcher]

connected to database but no tables.

[jggtz]

Try
http://forums.mysql.com/read.php?33,122269,122296

[iamresearcher]

still no tables