Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ssharrock
Starting Member
7 Posts |
 Posted - 2001-03-21 : 19:07:14
|
| Guys/Gals,I am in the throws of developing a Sales & Marketing application. Here is the general overview of what I want to acheive. I am looking for the best way to setup the database and connections for optimal performance. I have to write an application, (VB front-end), using SQL Server. I have the following site settings to worry about. I have 15-20 workstations on an NT LAN network. Most of these are desktops, but some are laptops which are plugged in the when they are in the office, but may also need to access the application remotely when they are out on the road, (they are salesmen). I also have head office needing to access the application. They will have 20-30 users maybe needing access. Some of these users will also need to look at the application remotely. We are connected via a frame relay that handles our AS400 (JDEdwards) and Lotus Notes traffic at the moment. I will also have another two branches but not sure of the configuration for them yet. I was thinking of replication to the branches so as not to tie up the frame relay during the day but was not sure of the remote machines. How to handle via dialup? If people need some more clarification, please contact me via email. Thanks in advance, Shane. |
|
|
|
|
|
What is the best way to approach setup?