CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com
Results 1 to 5 of 5
  1. #1
    Join Date
    Sep 2012
    Posts
    2

    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

  2. #2
    Join Date
    Jan 2006
    Location
    Fox Lake, IL
    Posts
    15,007

    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)
    David

    CodeGuru Article: Bound Controls are Evil-VB6
    2013 Samples: MS CODE Samples

    CodeGuru Reviewer
    2006 Dell CSP
    2006, 2007 & 2008 MVP Visual Basic
    If your question has been answered satisfactorily, and it has been helpful, then, please, Rate this Post!

  3. #3
    Join Date
    Sep 2012
    Posts
    2

    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.

  4. #4
    Join Date
    Jul 2005
    Posts
    1,083

    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 ...

  5. #5
    Join Date
    Jan 2006
    Location
    Fox Lake, IL
    Posts
    15,007

    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.
    David

    CodeGuru Article: Bound Controls are Evil-VB6
    2013 Samples: MS CODE Samples

    CodeGuru Reviewer
    2006 Dell CSP
    2006, 2007 & 2008 MVP Visual Basic
    If your question has been answered satisfactorily, and it has been helpful, then, please, Rate this Post!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  





Click Here to Expand Forum to Full Width

Featured