connection to remote server
I have 2 websites. On the first i have a table with news articles in an access database.
Now, my question:
On the second site i'd like to open the access-db on the first site and display these news. Both are on public servers, so i dont have the path for tha actual file. I use 'server.mappath("database.mdb")' in my connectionstring locally.
but how to connect to 'http://www.mysite.com/database.mdb'?
Cheers,
Per
Now, my question:
On the second site i'd like to open the access-db on the first site and display these news. Both are on public servers, so i dont have the path for tha actual file. I use 'server.mappath("database.mdb")' in my connectionstring locally.
but how to connect to 'http://www.mysite.com/database.mdb'?
Cheers,
Per
Hi
There is something called RDS (or MS Remote).
However these components are considered deprecated...
http://msdn.microsoft.com/en-us/library/ms811968
Microsoft advises using the SOAP Toolkit but Im not sure if that's the way to go here.
If the websites are located on the same servers I would see if it would be possible to set up a shared "Data" folder by the hosting company so that you could access it by file path. Access over HTTP is not prefered if you can find a solution going through a file share.
Hope this helps...
There is something called RDS (or MS Remote).
However these components are considered deprecated...
http://msdn.microsoft.com/en-us/library/ms811968
Microsoft advises using the SOAP Toolkit but Im not sure if that's the way to go here.
If the websites are located on the same servers I would see if it would be possible to set up a shared "Data" folder by the hosting company so that you could access it by file path. Access over HTTP is not prefered if you can find a solution going through a file share.
Hope this helps...
Selected Articles