Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations John Tel on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

VFP error reading file oddity

Status
Not open for further replies.

JOB2828

Programmer
Jan 21, 2005
17
US
I have written a vbscript that runs some simple SQL delete and insert statements using an ADO connection object with the Microsoft Visual FoxPro Driver. The problem ("oddity") is that I will get "Error reading file" on occasion. I can get around this message by running a statement trys to set a character field = to a number first. After it errors out because of the invalid type, I can then run the statements without a problem. The script is run from an XP workstation and connects to XP workstations through a mapped drive. The database files are foxpro free tables. Any ideas are greatly appreciated. If you need some more information or clarification, let me know.

Thanks
 
What version of the VFP OLE DB client are you using? Have you checked out the stability of this network connection? Obviously VFP will be exercising more than more applications.

Rick
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top