What is your select statement? Can you try to specify field output types using CAST ?
>Hello,
>
>In VFP 9 SP1, everytime we issue an SqlConnect() or an SQLStringConnect() i see in SQL profiler (for both SQL server 2000 and 2005) the following:
>
>
>select USER_NAME() select usertype,type,name from systypes where usertype>=257
>select USER_NAME() select usertype,type,name from systypes where usertype>=257
>exec sp_datatype_info 1
>go
>exec sp_datatype_info 12
>go
>exec sp_datatype_info -2
>go
>exec sp_datatype_info -3
>go
>
>
>In VFP8 only the first 2 line are present. It is hurting performance on our application (VFP9 SP1 dll's under COM+ application)
>
>Anyone know how to avoid the 4 calls to "sp_datatype_info"
>
>Thanks.
If it's not broken, fix it until it is.
My Blog