File Does Not Exist

[Jeffrey Ferreira]

I have a client using odbc client/server 5.20 - they migrated their app to a 64 bit version. On 2 files they are getting the following error:

Exception from HRESULT: 0xC0014020
Error at Purchasing Ledger Summary [ODBC Source [123]]: SQLSTATE: S0000, Message: [PxPlus][ODBC Driver][PXPIO]File does not exist;

they can query every other file fine. The file seems to be in the .ddf - has anyone ever seen anything like this?
thanks
jeff

[martinp]

Any luck? if every other file is working it shouldn't be too hard to figure out where the problem is?  field names? file path location? keys?

[Devon Austen]

A common thing I have seen is the prefixes not been setup correctly in the new DNS entry. If the necessary prefixes are not defined then some tables can't be found. You can check the path field of the table in the data dictionary, you should be able to confirm if the path is correct and setup correctly on the server and if a prefix is needed.

Another thing to check is permissions.