473,322 Members | 1,671 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,322 software developers and data experts.

Database Access over Internet

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

Oct 15 '05 #1
3 1763
Hi

Are you talking about a VPN? Check on whether your firewall(s) will support
this.
Also:
http://support.microsoft.com/default...b;en-us;323441

John

<le******@yahoo.com> wrote in message
news:11**********************@f14g2000cwb.googlegr oups.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

Oct 15 '05 #2
<le******@yahoo.com> wrote in message
news:11**********************@f14g2000cwb.googlegr oups.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

Oct 17 '05 #3
le******@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
Oct 19 '05 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

8
by: Adrian Parker | last post by:
Can VB connect to, and send SQL commands to an Access database sitting on a remote machine, via the internet? I don't want to just make an internet-viewable share. Adrian
9
by: Pacific Design Studios | last post by:
I'm running ASP on IIS 5. My users who are on the network can access our database. Any users from the internet "outside" the network can't access it. We don't have a firewall. Our Windows Server...
4
by: Nicolae Fieraru | last post by:
Hi All, I am working on a web site in asp which will be hosted on a Windows 2003 server. I use the following code to connect to the database: Set objConn =...
18
by: cjl | last post by:
Hey all: I know that it is silly in the age of Google to 'lose' something on the internet, but I recently checked out a project that had implemented a database with a subset of SQL in pure...
5
by: tom | last post by:
I have a local Excel spreadsheet I am potentially migrating to MS Access. The thought was to use Access on the workstation for data-entry and subsequent generation of mailing labels and other...
4
by: Russell Crosser | last post by:
I maintain an internet site. The host is linux based and uses postgres on the server. I wish to install a smallish database (of names and addresses +) on the host, and allow it to be accessed over...
0
by: Bill Thom | last post by:
I have a Microsoft Access 2000 (9.0.4402 SR-1) database that I am attempting to launch from a hyperlink using Internet Explorer (Version 6.0.2800.1106). If I attempt to launch the database from...
12
by: dennist685 | last post by:
How to get an Access database on the web from my own computer I have an Access database project in inetpub/wwwroot/Access2 . I build it, and then press cntrl-F5. - I still get the development...
6
by: LurfysMa | last post by:
I am working on an electronic flashcard application. I have one version up and running using Visual Basic (6.0) and Access 2000. My long-range plans are to put it up on a website and sell...
8
by: mouac01 | last post by:
I'm not sure if this is possible. I would like to have a PHP app on the Internet connect and write to a local database (Intranet). For example, users would go to a web site...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.