speed to coonectSQL Server over inernet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

What the minimal speed is required to connect to SQL Server over internet to
give a good connection?
I mean where i can open forms, select item from the list boxes, generate
reports, inputing data...

Thanks
José
 
The best way to work over the Internet would be to use Terminal Services or
a similar product like Thinsoft. Other possibilities would be to use
ASP.NET or .NET Winforms.

Excerpt for the most simple forms, you cannot really use ODBC linked tables
over the internet; even on a fast connection.

You can accelerate things by using sql pass-through queries or ADP; however,
these solutions requiert a lot of work and understanding of their inner
working. If you know what you are doing, you might be good using
pass-through queries or ADP over the internet; otherwise, your clients will
be less than satisfied.
 
Hi, I'm using ADP and I'm glad if the connection is up than 128kb I would
like to know the minimal aceptable.
 
Depends on what you are doing. Try it and you will see.

Also, take a look with the SQL-Server Profiler and try to diminush the
number of unecessary requeries made by ADP using sql strings and EXEC
statements instead of named parameterized stored procedures.
 
Back
Top