any alternate to remote sql?

[arnb71]

hello,
I have opened a free x10hosting account to do my research work. However, my work primarily involved remotely creating/updating/viewing database tables.
I am using C# .NET applications which access the database server remotely. However, I see that in many forum threads, it has been mentioned that remote server is not working due to security, although I see the functionality in c panel.

My question is, if remote sql is not functioning, is there some other technique to remotely work with the databases of x10hosting using C# .NET applications if any?


thanks

 

[essellar]

There's no reason why you shouldn't be able to broker the database access through a web service (which, for reliability on x10Hosting servers, would likely need to be written in PHP, necessitating hand-crufted WSDL). It will likely be more bandwidth-heavy, but you get, essentially, two levels of authentication: at the service level, and between the service and the database. CRUD should be easy enough, and you can separate your own access (as the database owner) from your application's access (as "world"), making things like accidentally-dropped tables and databases a lot less likely.

 

[misson]

If your research work requires .Net and remote access to an SQL server, the free X10 accounts aren't a good fit. Consider running IIS and SQL Server Express on a MS Windows box of your own.

 

[arnb71]

There's no reason why you shouldn't be able to broker the database access through a web service (which, for reliability on x10Hosting servers, would likely need to be written in PHP, necessitating hand-crufted WSDL). It will likely be more bandwidth-heavy, but you get, essentially, two levels of authentication: at the service level, and between the service and the database. CRUD should be easy enough, and you can separate your own access (as the database owner) from your application's access (as "world"), making things like accidentally-dropped tables and databases a lot less likely.

thanks I will investigate CRUD and hand crafted WSDL

 

[arnb71]

If your research work requires .Net and remote access to an SQL server, the free X10 accounts aren't a good fit. Consider running IIS and SQL Server Express on a MS Windows box of your own.

My IIS box and MS SQL server Express are totally up and running and fully tested. My next step is to analyse and test my applications in an actual remotely located server instead of a local ethernet based windows box.

I dont mind spending a couple of bucks for a paid hosting account but I didnt think it could be tricky to remote access a few harmless database tables
nvm
thanks

 

[arnb71]

So can somebody confirm that remote sql would be permitted if I took the 4.95$/month plan?