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
Printable View
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
help guys. I am using mysql odbc 5.1 driver.
help guys. I am using mysql odbc 5.1 driver and crystal reports 9
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.
Try using an ODBC and then in CR use OLE DB ADO / ODBC to connect to db with the created DSN
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.
You need to install the mysql driver 5.1 in your pc
http://dev.mysql.com/downloads/connector/odbc/
i have already install that driver but it did not solved the prob.
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
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
Well, now try with ODBC (RDO) / your DSN
connected to database but no tables.
still no tables