| Author |
Database Access over Internet
|
|
| le_mo_mo@yahoo.com 2005-10-27, 9:24 am |
| I was wondering if any body has used Internet as a WAN (Wide Area
Network) to provide database access. I know about web services but I
like to experiment with using Internet as a extended network (web
server behind one router and database behind another). Any ideas on
where to look for this?
Thanks
| |
| John Bell 2005-10-27, 9:24 am |
| Hi
Are you talking about a VPN? Check on whether your firewall(s) will support
this.
Also:
http://support.microsoft.com/defaul...kb;en-us;323441
John
<le_mo_mo@yahoo.com> wrote in message
news:1129345377.971147.100230@f14g2000cwb.googlegroups.com...
>I was wondering if any body has used Internet as a WAN (Wide Area
> Network) to provide database access. I know about web services but I
> like to experiment with using Internet as a extended network (web
> server behind one router and database behind another). Any ideas on
> where to look for this?
>
> Thanks
>
| |
| Brian Cryer 2005-10-27, 9:24 am |
| <le_mo_mo@yahoo.com> wrote in message
news:1129345377.971147.100230@f14g2000cwb.googlegroups.com...
>I was wondering if any body has used Internet as a WAN (Wide Area
> Network) to provide database access. I know about web services but I
> like to experiment with using Internet as a extended network (web
> server behind one router and database behind another). Any ideas on
> where to look for this?
>
> Thanks
Not the internet, but I used a wide area network a few years ago to
replicate a large SQL Server database across. The WAN ran at 64kbps, and it
struggled but we were replicating across half a dozen production sites.
So be aware that there may be a serious performance hit - it depends a lot
on the upload and download speeds at both ends of the connection and the
types of queries that you might be doing. Timeouts may also be an issue. Do
a serious assessment of the volumes of data you are likely to be moving.
As John has rightly pointed out, use a VPN.
Hope this helps.
--
Brian Cryer
www.cryer.co.uk/brian
| |
| Jon Dempsey 2005-10-27, 9:25 am |
| le_mo_mo@yahoo.com wrote:
> I was wondering if any body has used Internet as a WAN (Wide Area
> Network) to provide database access. I know about web services but I
> like to experiment with using Internet as a extended network (web
> server behind one router and database behind another). Any ideas on
> where to look for this?
>
> Thanks
>
Interesting idea,
Personally, I wouldn't trust public access without being able to filter
traffic though a PIX and a web service but please let me know how you
get on.
Regards
Jon
|
|
|
|