hi
i have installed ODBC driver to connect to mysql database but in vb 2005 it gaves me errors opps!!

is there any way to connect to mysql like access database
i see a tool called mysqldirect.net really wonderful but its not free :(

any way i want good way to connect to mysql database

thanks in advance.

Goto the MySQL site; on top of the MySQL driver that is there, there is also the ADO.NET connector: http://www.mysql.com/products/connector/ that has a plugin for visual studio

But, really, as long as the driver is installed on the server you could get away with using this as a connection string:
driver={MySQL ODBC 3.51 Driver};server=server;uid=user;pwd=password;databa se=database;option=16387;port=3306;

And then just use the ODBC objects found in System.Data.Odbc ;]

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from planoie's profile^^
^^Modified text taken from gbianchi profile^^
================================================== =========
Technical Editor for: Professional Search Engine Optimization with ASP.NET
http://www.wiley.com/WileyCDA/WileyT...470131470.html
================================================== =========
Why can't Programmers, program??
http://www.codinghorror.com/blog/archives/000781.html
================================================== =========