MySQL and VB.NET's Crystal Reports

[callraheel]

Hello
I need to connect MySQL Server with VB.NET and produce reports. One way is through ODBC but it takes much times so is there any alternative secondly i have to produce a picture from database and show it on report. So will anyone can propose a solution for both problems.
Regards

 

[ayozzhero]

Have you tried using MySQL Connector/Net? It is downloadable at: http://dev.mysql.com/downloads/

I've been using the common ODBC connector with VB .Net at it connects in just miliseconds. It might be your networking environment. Try starting MySQL with this option: --skip-name-resolve, i.e: mysqld.exe --skip-name-resolve

This way MySQL will not waste it's time resolving clients' names and use IP instead.

I am unable to help you with the second problem.