TS and new SQL Server 2000 app

From: er slansky (slanskye_at_hotmail.com)
Date: 06/21/04 

Date: 21 Jun 2004 09:38:18 -0700

I have no experience w/TS except for occasional connections at my main
workplace. As a side job, I inherited an Access 2k app used by a
small lab that I am converting to SQL Server 2k - it is just getting
too big with patient history and will only continue to grow. The new
front-end will be VB.net.

This lab uses XP boxes but connect to the Access app on Windows 2k via
Terminal Services; they say the performance is much faster because
they are directly on the server vs. passing data back and forth over
the network if they used individual copies of the Access program on
their desktops.

When moved to SQL Server, they want the same type of set-up. I'm
trying to convince them that SQL Server and Terminal Services should
be on different boxes. I can see maybe using Terminal Services to
connect to the front-end app, avoiding having to push it to the
individual XP boxes. But I'm thinking that just by going to SQL
Server, performance is going to improve anyway without having to use
Terminal Services.

Can anyone point me to something that would back me up on keeping SQL
Server and Terminal Services separate? And does anyone know how their
using Terminal Services would affect my VB.Net code? Design of the
database??

My experience is only with large employers who have several thousand
employees - I haven't really had to worry about how things are set up
as those decisions were already made.

Thanks for any advice or pointers,

ER Slansky

Relevant Pages

  • Re: Distributing application to customers?
    ... I assume your application is a Windows Forms app. ... If your customers expect to connect to you over the open ... I'd advise against connecting to SQL Server over the internet. ... that won't mind being trained on the intricacies of Terminal Services (e.g. ...
    (microsoft.public.dotnet.general)
  • Re: Performance issue after coverting from Framework 1.1 to 2.0
    ... I think that I encountered the same problem: A large program with Framework ... the SQL Server for the dev database. ... when you deploy the app on a different machine where the SQL Server is no ... app was fine on the dev machine. ...
    (microsoft.public.dotnet.framework.performance)
  • Re: C5 woes. How stable is VFP really?
    ... After that I close the SQL server cursor and work with my manual cursor instead. ... a VFP9 app on a really old machine ... app was under more "pressure", VFP showed ...
    (microsoft.public.fox.programmer.exchange)
  • Re: New to .Net
    ... a copy of Pro although technically you can build apps without it. ... "Paul Ilacqua" wrote in message ... I just need to get the syntax to build a VB.NET - SQL Server ... >> ui and do things pretty much like a full framework app. ...
    (microsoft.public.dotnet.framework.compactframework)
  • Re: Webservices - the way to go...?
    ... about your lack of secure network connectivity your between a rock and a ... To summarize the posts so far: you have a winform app. ... using a webservices data layer to handle all the database interactions. ... Upgrade your database to SQL Server. ...
    (microsoft.public.dotnet.general)