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
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