If I understand the QA correctly, it uses OLE DB to connect to SQL Server. Your SQLCONNECT uses ODBC, which is slower than OLE DB.
>In VFP 8, if I simply:
>
>s=seconds()
>c=sqlconnect('sql')
>=sqlexec(c,'open_inventory 11222','temp')
>?seconds()-s
>
>it takes about 1.3 seconds to execute the stored procedure.
>
>If I go into Query Analyzer and type:
>
>open_inventory 11222
>
>it instantly returns the query (probably less than .1 seconds).
>
>Any idea why VFP is so much slower?
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer