Im trying to set up an application that will connect to a MYSQL database across the a distance using internet connection. i did it with VB 6 but it seems like the connection is not that stable and sometime it wont connect. Is it because of VB 6? would be better if i use Vb.net? Should i make always make the connection active or just disconnect it when there is no process? I know for sure that internet connection speed can greatly affect this process, can a VPN connection help? i hope someone could advise me on this..
Jump to Post
Well, one advantage you would have with .net would be the disconnected dataset architecture. You would open a connection get your dataset and then immediately close the connection and return your dataset. That way you don't have to worry about the internet connection being reliable.
All 3 Replies
We're a friendly, industry-focused community of 1.19 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.