mySQL and VB6 or .NET

I have had someone ask me if there is a way to connect to a mySQL database from VB6 or VB.NET with out having to go and setup something on every users system like myODBC and a DSN in the ODBC control panel. Is there a way to design a program to use a mySQl database that you can have a user install that will not invovle a user to have to setup anything other then the program and all the Database stuff is just setup and works..?

No, pretty much not.
You can check into doing the ODBC setup and myODBC install through an installation script. This would require something other than the VB package installer though.

Onslaught thanks for the reply. I pretty much figured this would be my answer but I thought it did not hurt to ask. Had someone ask if that was possible. If you run a crossed any info to the contrary let me know.

Will do.

If you were prepared to accept a separate install that was only a double click on an exe and then a wizard like install with no configuration then you could try:
URL

The easiest what is the odbc drivers for mysql which can be downloaded here.

http://www.mysql.com/downloads/api-myodbc-3.51.html

there are also apis for .net technologies on the site for download somewhere as well