MySQL and Visual Basic 6.0

[php_stud]

Guys, do you have any idea how i can manipulate the contents of my database in MySQL to a Visual Basic Program?

[raf]

using ADO ?

i've used MySQL with ASP (VBscript with ADO through MyODBC driver) and it basically doesn't matter that much which db you use. If you use standard embedded sql (so no goodies for a specific db-format) than you can literaly just change the connectionstrings to slide another db under your application. I've once done such a replace of MsAccess to MySQL and once i've found the right driver, it went real smooth. So you basically could set it up for MsAccess with a more powerfull/cheaper MySQL version.

[php_stud]

Yes, using ADO. Thx. ok, all i need to do is to find the appropriate driver and install MyODBC...

[php_stud]

Thanks again, i got it working now... all systems go. Thanks a lot.

[raf]

You're welcome :thumbsup: Happy coding !