Re: ADO across vpn
From: William \(Bill\) Vaughn (billvaRemoveThis_at_nwlink.com)
Date: 03/03/05
- Next message: Val Mazur \(MVP\): "Re: Error 3251 - SQLServer"
- Previous message: Ralph: "Re: ADO and multiple forms"
- In reply to: JP Bless: "Re: ADO across vpn"
- Next in thread: JP Bless: "Re: ADO across vpn"
- Reply: JP Bless: "Re: ADO across vpn"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 2 Mar 2005 16:31:52 -0800
There are as many architectures you can choose from... these are just a few:
1) Create client/server application that connects to SQL Server or some
other serious DBMS over a LAN or WAN or via VPN
2) Create a web service the does all the data access and access the web
service from your application
3) Use terminal services to access an application running on a remote
server.
4) Create a web page that does the data access
Which do I recommend? Well, it depends on a dozen factors. It's like asking
what type of truck do I recommend to deliver pizza. In Redmond we would need
a little Toyota but in Baghdad, I suggest a Bradley fighting vehicle.
hth
-- ____________________________________ William (Bill) Vaughn Author, Mentor, Consultant Microsoft MVP www.betav.com/blog/billva www.betav.com Please reply only to the newsgroup so that others can benefit. This posting is provided "AS IS" with no warranties, and confers no rights. __________________________________ "JP Bless" <jp3bless_NoSpam@hotmail.com> wrote in message news:eduxjrmHFHA.1996@TK2MSFTNGP12.phx.gbl... > What would you recommend instead... Use VB on SQL, MSDE on WAN? > > "William (Bill) Vaughn" <billvaRemoveThis@nwlink.com> wrote in message > news:%23%232eDJUHFHA.3588@TK2MSFTNGP14.phx.gbl... >> First, you should be able to run the application without change over a > VPN >> (properly configured). >> Next, I would never do so--not if I cared about the data or the customer. >> When you open a JET database you're sharing a file over the network. This >> means every single physical IO operation is sent over the ether. Every >> SELECT you execute spools big hunks of the data file over the wire. If >> something goes wrong (and it always does), you're data can be corrupted > and >> the file can be damaged. If people connect to the shared file, you can't >> back it up until they close the file. You'll have to get them all to >> disconnect to compress or repair the file as well.I could go on but I > won't >> bore you with the details. >> >> JET was designed to serve as a local database store. It can be used in a >> limited way in a local area network but it has issues. It should never be >> used on a WAN. Using it as a you describe is foolhardy at best and >> irresponsible at worse. >> >> -- >> ____________________________________ >> William (Bill) Vaughn >> Author, Mentor, Consultant >> Microsoft MVP >> www.betav.com/blog/billva >> www.betav.com >> Please reply only to the newsgroup so that others can benefit. >> This posting is provided "AS IS" with no warranties, and confers no > rights. >> __________________________________ >> >> "KevinC" <Kclayton_rem@ve_ntlworld.com> wrote in message >> news:t6GTd.186$Rf.22@newsfe5-gui.ntli.net... >> > We have a vb6 application which connects via ADO to an access(Jet DB) >> > on > a >> > small local network workgroup server. >> > >> > We now have a vpn connection to two offices in other countries and >> > would >> > like them to be able to use the VB6 application from their offices. >> > >> > How do we need to change the connection strings/ Drivers in the VB6 >> > application. Do we need to use RDS or transactions. >> > >> > thanks >> > >> > >> >> > >
- Next message: Val Mazur \(MVP\): "Re: Error 3251 - SQLServer"
- Previous message: Ralph: "Re: ADO and multiple forms"
- In reply to: JP Bless: "Re: ADO across vpn"
- Next in thread: JP Bless: "Re: ADO across vpn"
- Reply: JP Bless: "Re: ADO across vpn"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
