Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
ODBC to remote machine
Message
From
22/01/2002 17:38:15
Amy Ready
Fowler Software Design
Denver, Colorado, United States
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
ODBC to remote machine
Miscellaneous
Thread ID:
00608685
Message ID:
00608685
Views:
55
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
Map
View

Click here to load this message in the networking platform