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..
bornok15
3
Junior Poster in Training
Recommended Answers
Jump to PostWell, 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
Reply to this topic
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.