Databases over the internet.

[LucaUWF]

No doubt a very simple question for you guys, but as I'm only just starting out in Database and Internet Apps, it's one I could do with a little help on.

If I am to try and connect to an access DB do I actually have to own the web server in which to host it? As from what I gather you need to form an DSN for it in which to connect to.

I'm sure I won't have to... so is it possible to simply host your database on (For example your ISPs) web space and connect to it there?

Any help whatsoever will be useful at this early stage.

TIA.

[PilgrimPete]

No. You don't have to own the web server.

Each ISP will be different, and will host different databases in different ways (and for different rates). You'll need to do a bit of research as to which one is best for you (and your RDBMS).

I'd advise against using a DSN too. They're pretty inflexible beasts, and a DSN-less connection is pretty simple to set up.

[LucaUWF]

So, if I understand correctly, what you're saying is that I would have to create the databse, then have my host actually host it on their web server and set up a connection?

I assume I couldn't just upload the DB to my own space right?

[PilgrimPete]

Depends on your database... obviously you could just upload an Access db; SQL Server or Oracle will almost certainly require some human intervention at the ISP.

[LucaUWF]

Hmm... seems that I have been totally misled then.

I was told that it wasn't possible to simply upload a MS Access DB to your webspace and connect to it with ADO.

[PilgrimPete]

I've done it.
I used www.brinkster.com but only because they're free; but there are loads of sites that will host your Access db.