error reading file.

[brianpercival]

I have an issue.. Over the network, I have a server with vfp free table directory. I created a odbc dsn to access this directory. THen I use coldfusion to access this odbc dsn and connect and read some data from one of the tables (this particular table has a million and half records)

Everything worked fine for a while, even though it was very slow etc, but suddenly I get "Error reading file" error msg from the odbc driver whenever I try to read it.

I am able to read other tables in the directory without problems. Don't know what is happening..

Any ideas?


regards,
Teja

 

[RickSchummer]

The error is triggered because the operating system is reporting an error reading the file. Is the file already open when the error occurs? What is the code doing when the error is thrown?

Is it possible the table or index is corrupt?

Which version of the ODBC driver are you using?


_RAS

http://www.whitelightcomputing.com

Shedding Some Light (blog)
VFP MVP

 

[brianpercival]

Ricksummer,

thanks for the response. I restarted the server (on which the odbc is created) and it works fine now. No clue what got corrupt where.. I cann't say the vfp database file is corrupt because another application uses it without any problems. So I have to guess that it is something on the machine where the odbc socket is created.


regards,
Brian

 

[RickSchummer]

I probably should have asked what type of network. I have seen this exact issue on Novell Networks where the Server just would not let go of a file.


_RAS

http://www.whitelightcomputing.com

Shedding Some Light (blog)
VFP MVP