-
September 22nd, 2012, 07:49 PM
#1
mysql database - local access from vb6
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
-
September 22nd, 2012, 09:16 PM
#2
Re: mysql database - local access from vb6
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)
-
September 22nd, 2012, 09:28 PM
#3
Re: mysql database - local access from vb6
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.
-
September 24th, 2012, 08:42 PM
#4
Re: mysql database - local access from vb6
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.
JG
... If your problem is fixed don't forget to mark your threads as resolved using the Thread Tools menu ...
-
September 25th, 2012, 01:18 AM
#5
Re: mysql database - local access from vb6
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|