>I have created an ODBC Datasource using the Visual Foxpro Driver to point to a network drive location containing Foxpro free tables. In the ASP file, i create a data object successfully, however when trying to execute a simple Select statement. ie "select
from plu" i get the following message:
>
>Technical Information (for support personnel)
>
>Error Type:
>Microsoft OLE DB Provider for ODBC Drivers (0x80040E37)
>[Microsoft][ODBC Visual FoxPro Driver]File 'plu.dbf' does not exist.
>/codesearch/CodeSearchResult.asp, line 35
>
>The interesting thing is when ODBC datasource points to a local drive containing the same Foxpro Table, it will work.
>
>Anyone have any ideas?
>
>Thanks in advance
>
>George
Hi George,
What kind of data object are you using? What ASP editor? For example, if you are using VI, are you doing the ADODB stuff in script, or using the DTCs?
The error itself sounds like a pathing thing, but so long as the DSN is pointing to the folder where the DBFs are, you should be fine. Weird.
Does the IUSR account on the web server have permissions on the folder containing the tables? I am not sure if this is required for a DSN style connection, but you never know.