speed to coonectSQL Server over inernet

[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é

 

[Sylvain Lafontaine]

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.

 

[Guest]

Hi, I'm using ADP and I'm glad if the connection is up than 128kb I would
like to know the minimal aceptable.

 

[Sylvain Lafontaine]

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.