Help with R&R SQL & DBF files

[timjacob2001]

I^m trying to run R&R SQL v 12.5, and would like it to read from some DBF files. When I create an ODBC Data source using the Microsoft dBase VFP driver, I get the below message when I try to connect. ____"No table names were found for this data source"____The Directory is G:JNBDB3 (a network drive). There are 801 DBF files there, of which 509 have CDX index files. I told it that it was a Free Table Directory.____I need to be able to relate, at least temporarily, SQL Server and DBF files in a report.____Can anyone give me a clue as to what I^m doing wrong?____Many thanks__Tim____

[kfleming]

Why not simply use the Xbase version of R&R since it is designed to work directly with Foxpro tables?____Kathleen__R&R Support

[timjacob2001]

Because I also need to look at a SQL table. Is there a way to do it?

[kfleming]

There is not a way to combine two different data sources in a SQL report. What you need to do is export to DBF from the SQL side and then write an Xbase report to combine the exported DBF and the native DBF.____Kathleen__R&R Support