>I have a visual foxpro application that is using sql server as its database. Some of our users are experiencing difficulties connecting to sql server.
>
>They seem to make the connection to sql server , but are experiencing extreme difficulties when a sqlexec command is issued. For example:
>
>lcSQL = 'SELECT * FROM ' + lcTable
>
>lnSQLResult = SQLEXEC(gnConnectHandle, lcSQL, lcTempCursor)
>
>
>
>Some users experience no problems and others are finding that when the above code is issued , the system seems to hang.
>
>We are using TCP/IP protocol.
>
>Any suggestions would be greatly appreciated.


How big is the table? Pulling in all columns from all rows can be an extremely expensive operation, particularly if the workstation doesn't have a lot of memory. It may not be hung, it may just be very SLOOOOOW.

Mike