Get rid of the SIZE parameter in your connection string and try it.
>The query which I am running on the server is:
>
>ls = SQLSTRINGCONNECT("driver={SQL Server};server=(local);database=AWS2;uid=aspnet;pwd=;Trusted_Connection=Yes;size=8192")
>lnstart = SECONDS()
>? SQLEXEC(ls,[Select squeezedesc From inv Where SqueezeDesc like 'thehook%'])
>? SECONDS() - lnStart
>= SQLDISCONNECT(0)
>
>The connection used by QA is windows authentication.
>
>Glenn
>
>
>>That gets a little more interesting..
>>
>>Are you using the same connection type in query analyzer and VFP (SQL authentication vs Windows authentication)?
>>
>>Is the VFP time including time to connect? If so, how long does it take AFTER you have a connection handle?
>>
>>>For this query only 21 records are being returned. Ant I can execute this query both remotely and on the server with the same results. I ran the sql profiler and the query appeared to be the exact same as the analyzer.
>>>
>>>Glenn
>>>
>>>>How many records are being returned?
>>>>
>>>>If there are lots of records in the result set then it could simply be a network throughput issue assuming you are running query analyzer on the server (no network issue there)..
>>>>
____________________________________
Don't Tread on Me
Overthrow the federal government NOW!
____________________________________