Foxpro, Coldfusion File Read Error

I’m right in the middle of final testing for my UPSConnect/Coldfusion app and I started  to see a bunch of errors popping up in my logs and my app stopped working.

The specific error was

[ODBC Visual FoxPro Driver]Error reading file

Hmm. I verified that the remote folder was accessible and the datasource verified in CFAdmin. Still no go.  Couldn’t even perform a simple select on any of the dbf files

One thing is different today is I’m testing after UPS End of Day procedure has been run. This procedure “archives” the days shipments by copying them into new tables and emptying the working tables.  So I thought maybe there might be an issue with the driver accessing empty tables (although I was 99.9% sure that I had selected on empty table before)

Then I had a thought.  Uncheck good old ” Maintain connections across client requests”  in CFadmin>Datasources>Advanced Settings

Sure enough, that fixed the problem. I can select on my tables again.

Now I’m not sure -why- my datasource would work for 2 months with this setting enabled and then -not- but at least it’s working.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: