Accessing database from client-side - asp.net/sql

[Abraham]

Hoping someone may be able to shed some light on a situation for me.

The basic situation:
Externally hosted website with sql database backend
One user interface of the website is restricted by IP to requests coming from within my company.
As part of that interface I would like to pull some data in to auto populate the form.
The only problem is the data I want to get is on a database within my company, so all of the users of this part of the site will have local access to the database.

So my question is, Can i connect to a client-side database from an asp page?

I really need to make the connection this way as i cant connect to my hosted database from a local web server and i cant connect to the local database from the hosted server.

Any help will be very much appreciated

 

[stx666]

Dependant on data needs, try setting up a view with limited permisions and exposing that view as a webservice that the external website can then query.