Client connection to SQL Server on shared hosting

[Jo Davis]

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

[Trevor Best]

Jo Davis wrote:

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.

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.

--
This sig left intentionally blank

[J. Clay]

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
"Jo Davis" <[e-mail]> wrote in message
news:42******** *************** @news.aaisp.net .uk...

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

----== Posted via Newsfeeds.Com - Unlimited-Uncensored-Secure Usenet News==----
http://www.newsfeeds.com The #1 Newsgroup Service in the World! 120,000+ Newsgroups
----= East and West-Coast Server Farms - Total Privacy via Encryption =----