Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SQL Server connection speed
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Divers
Thread ID:
00179243
Message ID:
00181059
Vues:
20
It turns to be a bug in the network data binding.

>It may have to do with your security setup. The laptop may not
>be part of the domain or something like that. Different user,
>different security checks...
>
>+++ Rick ---
>
>>No, we are not using TCP/IP. I have tried and I get an error. I think SQL Server has to be setup on the server to handle TCP/IP and I don't have that control.
>>
>>The stange thing is that a laptop can run real fast connecting to SQL Server and my desktop works slow. If I put the laptop on the wire it is still slow. There must be some network connection on my desktop that is off.
>>
>>Help!!
>>
>>>The most notorious problem I know of in when you are using IPX. A client using IPX as a network protocol always seems to run really slow vs. SQL server.
>>>
>>>I run my networks with just TCP/IP and NetBeui for this reason, but I know that is not always an option.
>>>
>>>You could try also try screwing with your SQL server setup to use IP instead of Named Pipes. I've added IP transport but never removed Named Pipes so I'm not sure what to tell you about that.
>>>
>>>If this isn't the issue please post again.
>>>
>>>>We have several machines on Windows 95 and 98 and NT 4.0. On some of the machines the connection speed is several times slower than others. We have switched connections to hubs to make sure the hub is not at fault. We have a feeling that it has something to do with the Windows network setup. Has anyone encountered this?? Any solution?
>>>>DLC
DLC
"Use the Right Tool for the Job!"
davidandcynthia@email.com
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform