Hosted SQL Server

philjayj

philjayj

philjayj

Associate
Joined
25 Jul 2004
Posts
803
Location
.
Hi Guys. I have a database which makes use of the Royal Mail's PAF. Because of the size of the PAF, I want to store it in a SQL server database.

Now, I don't want to set a server up at home, so are there any SQL server hosts out there, which aren't for the purpose of hosting websites?

I don't know if its possible, but can I create a database connection within my PCs data sources which links to a hosted SQL database?

Many thanks

Phil
 
Did you want to use MS SQL or MySQL?

Most hosting providers will by default set you up with a base OS install and then you can get on with whatever else you need to do. If you need some guidance as well as ongoing support with the setup, it might be worth going for a managed option.
 
As long as I can connect to the database from within an Access DB, then it doesn't really matter if its Microsoft SQL or MySQL.

Support isn't really that important. Providing we can establish a connection via an ODBC link or DSN-less connection, then we should be OK without a support package.
 
I guess the problem is going to be security as effectively if you can connect to it so can other people (you could lock it down by IPSec, etc.) also the connection over the internet isn't going to be fast. You're better off hosting it yourself (perhaps a Virtual PC that you turn on when you want to use it?)

There are people who host SQL servers out there:

http://letmegooglethatforyou.com/?q=sql+server+hosting




M.
 
You could, assuming the resources on your local PC are of, just install MS SQL Server Express (like MSDE) and pop it in there running in the background.

Obviously not much use if you need to share the DB while your PC is turned off or there is some other reason not to put it there. It will probably work fine as long as the DB is the right size to fit in Express.
 
Of course there are hosting providers who can offer you SQL server.
Click to expand...

I know there are, but the majority of them seem to have a primary business focus on hosting websites - what I want isn't related to websites. I just want an offsite SQL database which I can connect to via ODBC.

The providers I have found have limitations on database size etc, and very slow response times.

If you have any suggestions, it would be appreciated.
 
You must log in or register to reply here.
Back
Top Bottom