mysql database - local access from vb6

[markschum]

I need to clear and write a mysql database from a local laptop for later update to a website for readonly access via web browser.

The web side of things is being written now but the laptop end is a problem. The methods I can find use mysql via a local website which is not what we want to do.

Anybody know a way to use a mysql database from vb6 without requiring Mysql installed ?

regards

[dglienna]

Not without MAGIC, but, that's not what you need to hear. Why CLEAR a DB that doesn't exist, then write another one? If you have one, you can upload it to a site that has MySQL, and access it from your VB6 program.

Find a webhost that provides a DB Server for your use. (Most do)

[markschum]

The customer spec I was given is for a staff member to edit a database on a local laptop while travelling and then upload and replace the current website database from the laptop.

I have suggested another database application for the laptop and an update to the website but it was deemed "very complicated"

It sounds like I let them find someone else to handle the project.

Thanks for the response.

[jggtz]

IMO
The application in the laptop could use any database (Access, Mysql, SQL, etc.)
Use the one you like more
Do not search for mysql, search for VB6 & ADO instead
That's the tool you'll need to develop the local application

And about the 'updating part'... it could be an option in your application
You could connect directly to the website database or you could send the day's transactions and develop a small application in the server side... etc.

[dglienna]

Sounds like a shared space on any FREE service would be better. Everyone could update LIVE data, and nobody would have customer data on their laptop.