how to use DAO and MySQL ?

[farhan26]

hi, i'm using VB6 to develop the attendance system. but i dont know how to interact with server database(MySQL). can u explain about DAO and hot it interact with MYSQL? i'm using MS Access for local database.

[wildfrog]

but i dont know how to interact with server database(MySQL).First of all, as I pointed out in your previous post, you need the MyODBC connector. You can find it on www.mysql.com.

can u explain about DAO and hot it interact with MYSQL? i'm using MS Access for local database.Are you using MySQL or MS Access?

- petter

[Shuja Ali]

hi, i'm using VB6 to develop the attendance system. but i dont know how to interact with server database(MySQL). can u explain about DAO and hot it interact with MYSQL? i'm using MS Access for local database.As already pointed out by Peter, you need a myODBC connector.

Now regarding your question of DAO, I don't think you should use DAO to access mySQL, you would be better of using ADO 2.8. ADO is better and more efficient compared to DAO. And DAO is an old technology. If you developing anything new, you should use ADO unless you have strong reasons to use DAO (Which I don't think you will have).

If you are new to ADO, I would suggest that you grab a book and learn about ADO before you start the real project. And search aorund th forum, I am sure you will get lots of samples.

[exterminator]

...you would be better of using ADO 2.8. ADO is better and more efficient compared to DAO. And DAO is an old technology. If you developing anything new, you should use ADO unless....If you strictly go by this argument, suggesting ADO.NET would have been a much superior suggestion ;) . Regards.

[Shuja Ali]

If you strictly go by this argument, suggesting ADO.NET would have been a much superior suggestion ;) . Regards.
Well the OP says that he is using VB6, so ADO would be the only choice there.