Bob,

What table is the counter iterating through?

Are you letting the remote view create the connection of are you using SQLConnect() first and then opening the view...

Perhaps the view is looking in the DBC for a connection with the name you specified, and then when that is not found it looks for the DSN.

Other than that, I am not sure... but, I don't think it is going through the back end database, it is looking at something client side.

Also, when the connection happens, if you are letting the view do it, if the SLQ server ODBC Dll is not loaded, that needs to be loaded... but you say you quit fox and then go in, so the .dll should still be loaded.

BOb


>I am, thanks alot. I do have another question that hopefully you can shed some light on or lead me in the right direction.
>
>I notice that the FIRST time I do a SELECT from the foxpro command window using either a remote view, ADO or DSN connection that it appears foxpro sequentially goes through the entire remote SQL database. I say this because the FIRST select on the database is slower and I can see the counter in the status bar iterate through the entire table. After the first select, subsequent selects are fast and I do not see the counter.
>
>If I quit foxpro, the process starts over, that is, the initial select does the above. I checked my index on the SQL side and they are their. Even the most simple select does this.
>
>Any insight?
>
>Thanks,
>bob