Visual Fox Pro - connecting to db - "File xxx does not exist"

[marcalo]

Hi,
I have been trying to connect to a Visual Fox Pro database.
Everything works fine when I store the db locally. However, when I point the DSN to another computer in the network it gives me the following error:

Microsoft OLE DB Provider for ODBC Drivers (0x80040E37)
[Microsoft][ODBC Visual FoxPro Driver]File 'cartndtl.dbf' does not exist.

The computer where the db is uses Win Xp Pro.
I set permissions to everyone, including _web applications and _web anonymous users.
When I use a local software to run queries it works but the software does not display all the tables.
I also tried using linked tables in MS access and it worked.
Any idea?
Thanks,
Marcalo

 

[DreXor]

and i'm assuming you've validated/tested the DSN via ODBC manager for proper connectivity before trying your application ?

DreX
aKa - Robert
if all else fails, light it on fire and do the happy dance!