This has been discussed before. Sorry I can't point you to a specific thread.
Using a DSN on a mapped network drive does not work reliably. However, you can access a table natively (i.e. USE ) through a VFP COM component and return the results to your ASP page.
-Dave
>I have a file server that has FoxPro 2.6 tables on it. I need to access those tables from the web server via an ASP page. The web server and file server are in the same domain and I made sure that I opened up the security all the way. For testing purposes I gave the IUSR_computername full access rights to the directory where the files are located. I setup an ODBC DSN that points to a mapped drive where the FoxPro tables are located. I know that this path is correct. However, when I try and open a recordset in my ASP page to access the FoxPro tables it gives me this error:
>
>Microsoft OLE DB Provider for ODBC Drivers (0x80040E37)
>[Microsoft][ODBC Visual FoxPro Driver] File 'shipment.dbf'
>does not exist.
>
>I know that this table does exist in the directory that is specified in the DSN. Does anyone have any ideas on this? Thanks.