I have hostgator, bluehost and an off company called ADL - all of which don’t seem to be happy giving me the ability to edit the timeout for SQL databases hosted on the server.
So I have a concept for a multi-user desktop application that can’t even stay connected to a web based database for more than like 60 seconds
ISO - a hosting service that allows me to setup and manage any number of SQL databases, without restrictions - for a fair and reasonable price.
or maybe im just oblivious to what I should be doing to work around this problem lmao!
quote=174060:@Robert Tafoya
ISO - a hosting service that allows me to setup and manage any number of SQL databases, without restrictions - for a fair and reasonable price.
or maybe im just oblivious to what I should be doing to work around this problem lmao![/quote]
For full control you will have to get yourself a virtual private server.
I think you need to paint us a better picture of what you are trying to do here, because needing to be connected to a web based server for more than a few seconds at a time is unusual.
Is there a web based service between your desktop application and the database or are you trying to connect the desktop app directly to the database for a start?
It can, yes. Your desktop app would simply make calls to the remote database. This should be done through an intermediary such as a PHP page that accepts your request, talks to the database to retrieve and write records then pass that info back to your app.
You can have your desktop app talk directly to the remote DB but this is not recommended because your database will be open and exposed. Rather, the PHP site is hosted and connected to the database and it is the only allowed service to connect to the database. This adds a layer of complexity but also adds a much needed layer of security. Read up on PHP and SQL, it is not nearly as complicated as you would think. Additionally you can connect to the PHP page from your app through SSL and use simple HTTPS calls and posts to retrieve and write data.
In this scenario you can have many desktop apps talking to the database.