Avatar of AIGS
Flag for Australia asked on

Write standalone program to use MYSQL database

I have a MYSQL database hosted on website
I want to create a standalone program to run on windows PC that will use the MYSQL database to display appropriate data
The standalone program must be able to run external programs that are on PC that the database refers to
Any suggestions on the approach, language etc would be welcome.
DatabasesWindows OSPCVisual Basic ClassicMySQL Server

Avatar of undefined
Last Comment
John Tsioumpris

8/22/2022 - Mon

You would need to provide more detailed info on what resources on the PC the application shou,d be able to call on?
Do you have visual studio that you will be creating the application? You would need to get the MySQL odbc driver.......
John Tsioumpris

The easiest and fastest way for such kind of operations is Ms Access...here is a small demo of a project i am working right now (very early stage)
The data come from my VPS server located over the Internet so you are seeing a data retrieval of 1000 rows with 25 columns and then the transfer to Excel Spreadsheet...

John - I was using MS Access 2010, when we had the data in Access stored on our server, worked well.
Since we changed over to MySQL keeping the data on our website host and after setting up ODBC connection for the same access front-end, I can see the tables and run queries, but using treeview to display the data in a form is not working. It seems the recordset that is created loads too slow  and causes form to freeze! - aigs
This is the best money I have ever spent. I cannot not tell you how many times these folks have saved my bacon. I learn so much from the contributors.

View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
John Tsioumpris

The problem is that lot of people believe that by switching BE to MySQL...is like a magic pill...well it isn't..it requires considerable homework.
Probably it would be better if you create a Gig...

I have a database which I want to use on externally hosted website and I also need to use it on out internal network. At the end of the day it doesn't really matter if it is in MYSQL or MS Access.
The current front-end (forms) to use the database is in MS Access (in the past this has worked fine when data and forms have both been on the internal network).
As the external website is written in php, I thought I could use MYSQL on external website and use MS Access front-end on internal network (which would link to MYSQL database) - it does work but very slow and causes some issues in retrieving the data.
So, would I be better in having the data in MS Access on internal network and connect to it with php from external website using PDO ODBC to be able to view data on website?
I only want to have one master database but be able to access it from external website and also our internal network - I don't want to have to copy data from one to the other when changes occur.
Am I barking up the wrong tree or is this feasible?
John Tsioumpris

Well probably you didn't saw my demo ...lets take it again....if you use MySQL as Access its going to be slow...dead slow....if you have a lot of records you would probably "see" timeouts ..and the whole process...is slow...
On the other hand if you use MySQL as MySQL then you will have a database solution that works globally speedy and efficiently...a quick and dirty example right now....fetching 1000 rows and 90 columns on my VPS (1 core Intel® Xeon® E5-2650L v4, 1Gb Ram...over Wifi from accross the street router  (not on the same room) over ADSL ...ping around 2-3 ms...or more ..:)   ) ...time less than 10 seconds....(keep in mind i haven't designed the database)
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.

In the end - after more research I found using dbOpenSnapshot & dbReadOnly with dbOpenRecordSet solved the issues for siaplaying data in a TreeView.
John Tsioumpris

Well....this my 2 cents