>>Helo,
>>
>>I'm having hard time running SQL Select command on Visual FoxPro View. It seems that ASP Cannot read from FoxPro view. I run this statement: "SELECT * FROM MYVIEW" and i receive the following error message:
>>
>>Microsoft OLE DB Provider for ODBC Drivers error '80040e37'
>>[Microsoft][ODBC Visual FoxPro Driver]File 'MyView.dbf' does not exist.
>>
>>Myview is a FoxPro regular View. Is there something specefics to set before using Visual FoxPro view in ASP Code?.
>>
>>thanks in advance.
>>
>>Erick,
>>You go with what you know at the time.
>
>Post your code?? If you have a view, why not just make a parameterized view and requery it?
>
>Wayne

I have this same thing happen local (.dbf not found) if the view is not in the current open database. To get around this use databasename!viewname as in SELECT * from DB!MYVIEW

I don't know if ODBC will like it but it works local.
-Dave-