Client connection to SQL Server on shared hosting

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jo Davis - 08 Mar 2005 06:35 GMT

I'd like to do this:

Have a SQL Server database hosted on a public facing web server.

I want it to be held at an ISP/Web hosting company. Though I have ADSL here
I don't want to manage a server.

I want some ASP pages accessing the database.

I would also like for a very small number (probably 2) of users to access
the database from a richer client. Perhaps Access/VB.

I've tried using www.shanje.com, as a test. It seems to work, though there
are worries about security.

I want to keep cost down!

On 'normal' shared MS hosting, would it be possible to connect to the db
from a client like Access. The way most web hosts talk it doesn't look like
it.

Is there any way of providing a richer client interface than plain web
pages? I want things like autocomplete (beyond the first character) for drop
downs, keyboard shortcuts etc.

This would be low volume. Essentially a private database held on the
internet.

Yours, Jo

Reply to this Message

Trevor Best - 08 Mar 2005 08:43 GMT

> I'd like to do this:
>
[quoted text clipped - 23 lines]
> This would be low volume. Essentially a private database held on the
> internet.

It's possible but avoid ODBC linked tables, these will require
re-linking periodically or when the user changes to keep the security
context and relinking over the net (even with broadband) is sloooooooooow.

You could use an ADP but check this group (the Access one) for pitfalls
about that.

About the best bet is to use unbound forms and controls, etc.

Signature

This sig left intentionally blank

Reply to this Message

J. Clay - 08 Mar 2005 16:01 GMT

Mosts host as far as I am aware would block any attempts to attatch direct
to the SQL Server from an outside application. In my opinion it would be an
extreme security issue if you could gain access direct.

With that in mind, you will probably need to look into some type of Web
Service using XML or SOAP, etc.... I know enough about this to make a fool
of myself :) Anyway, you would need to make a call to a page on your site
that can see the database and return the appropriate data to you
application. From my understanding, this is one of the benefits of some of
the newer technologies including .Net.

Good luck,
Jim

> I'd like to do this:
>
[quoted text clipped - 25 lines]
>
> Yours, Jo

Reply to this Message