>I have a VFP 3.0 application using remote views and a named connection to an Informix database. The response time, both to establish a connection via USE view_name NODATA, or REQUERY('view_name') is in the order of 3-4 minutes. My development system is a 120 pentium, 64mb RAM, 1.2 gb HD. The Informix database is accessed over a shared T1 WAN.
>
>If I connect to the same tables using the same ODBC drivers via Crystal Reports or using different drivers on another SQL program, the response is within 3-5 seconds. Response is also excellent if I execute the queries using SPT at the VFP command window.
>
>Anyone out there have a similar experience or suggestions on a fix? TIA - Bob
You don't happen to have tracing in ODBC, do you?
Alexandre Nobre
Alpha Bytes Computer Corp.
Did you know that there are innocent people dying in East Timor?
It helps if you do...
I suppose you don't need glasses if you're able to read this line