Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL Server connection speed
Message
 
To
22/01/1999 18:02:44
Eric Barnett
Barnett Solutions Group, Inc
Sonoma, California, United States
General information
Forum:
Visual FoxPro
Category:
Client/server
Miscellaneous
Thread ID:
00179243
Message ID:
00179617
Views:
33
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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform