Connecting to a Distant SQLServer Using ODBC

  • Thread starter David C. Holley
  • Start date
D

David C. Holley

Anyone have any experience connecting to an instance of SQLServer on a
server that is rather distant from your local office? (EX: Office in
Chicago, Server in Atlanta)
 
T

Tom van Stiphout

On Thu, 4 Mar 2010 19:10:37 -0500, "David C. Holley" <David.C.Holley>
wrote:

Yes. Worked fine. What's your challenge?

-Tom.
Microsoft Access MVP
 
D

David C. Holley

Lack of experience with it and on a very-high profile project. I'm going
into it blind as a bat.
 
D

david

Yes, slow.

Never had a user that actually liked the experience.

Never bad enough to make management think that
the users had a problem.

But bad enough to make management think that management
had a problem if management had to use the application.

And that was using a fairly well designed application.

Depends a lot on the network infrastructure, not so much
at all on how far physically.

Latency is more important than through-put. Or at least,
you can fix through-put problems just by fixing up your
design.

Exaggerates all of the problems of ODBC-linked table design.
-- complex multi-table joins will be candidates for re-design
as views.

(david)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top