CR 8.5 and VFP 5.0 data access

[FoxGolfer]

I have created an app for a client and the data is stored in a VFP5.0 dbc. (I have also installed the app with runtime libraries on two other machines with data always being retrieved from one machines hard drive.)They have created a peer to peer network and the CR8.5 reports and on two of machines when we try to run the reports using the same ODBC connection that works fine on the "main" hard drive, a simple listing report works fine but adding a date specific query results in 0 records. I've gone through the "Set Location..." and noticed that on the two machines when creating a DSN and ODBC, only VFP tables is an option, NOT VFP database. I've reinstalled CR and VFP run time and still no luck. The date specific reports works fine on the main machine. ??
Any help would be appreciated.
Tom

 

[synapsevampire]

What does a "main" hard drive mean?

And what is this date specific query, does this mean using a date parameter?

Which driver are you using?

Using proper technical terms and fleshing out details should help describe your situation.

Try downloading the latest drivers, and if you're specifically pointing at a table, make sure that you can use the ODBC connection from other apps, such as Access.

-k