General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
ODBC to remote machine
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.
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only