yet another DB question

[mannish]

I am trying to set up a SQL database for use with a desktop application. I set up the DB OK - I point the application to DB but it does not connect

The only thing I can figure is maybe I should point the app to hostmonster.com instead of the actual website address..?

Do I need 'permission' somewhere to allow desktop app to talk to the DB on HM...?

Gimme a tip I am a mainframer trying to help out a non profit organization in my spare time

thanks

[shadmego]

You need to allow the remote IP address (of the desktop running the app) access through two firewalls. The first is in the CPanel area (the name of which escapes me right now) and the other is in the account area of the HM account. I don't have access to my domain right now, and am waiting for a response from Live Chat or I would search and tell you exactly where to go to get access remotely.

I CAN tell you it is possible, because I'm running a remote access application to manage some databases of mine.

~regards, and welcome to the community

I wish I had more info for you.

[r2b2]

Be warned though - it's most likely against the TOS to use the account just for the database (well I imagine it would be since your not allowed to use the account for file storage etc.)

(i.e. if your remote application updates a database used by a web page/application running on your account you should be ok. If there is no web page/application running on your account and using the database it may be against the TOS)

[KevCo]

Be warned though - it's most likely against the TOS to use the account just for the database (well I imagine it would be since your not allowed to use the account for file storage etc.)

(i.e. if your remote application updates a database used by a web page/application running on your account you should be ok. If there is no web page/application running on your account and using the database it may be against the TOS)
:confused:
What, exactly, does this all mean? Could you elaborate, especially the bolded part?

[r2b2]

From the TOS:

Backup Storage. HostMonster.Com offers its Services to host web sites, not to store data. Using an account as an online storage space for archiving electronic files is prohibited and will result in termination of hosting services without prior notice.

So basically anything stored in your HostMonster account needs to be related to hosting of web sites. (Or at least that's the way I read it...)

[anonymous]

I am trying to set up a SQL database for use with a desktop application. I set up the DB OK - I point the application to DB but it does not connect

You'll need a web interface that will interact with your desktop ap. Something like: mycoolsite.com/mysql1.php?parm1=11&parm2=abc. mysql1.php would accept parms parm1 and parm2 and run some sort of sqlback and return that results back to the browser.

If your desktop is java, you could use the URL object. If php you can use the CURL function. If perl, use the equivalent function. Some people call this screen scraping. By using this technique, you don't have to worry about enabling some specific IP, which means you can run your desktop ap anywhere. Of course, you'll have to secure you php backend from unauthorized people. Use SSL plus other authentication means......

[KevCo]

From the TOS:


So basically anything stored in your HostMonster account needs to be related to hosting of web sites. (Or at least that's the way I read it...)Thanks, I didn't know that.