ODBC Driver and cdx files
Posted on 2011-09-23
Hi there. We have an older FoxPro program that has a table with some memo fields in it that a user wants to be able to query with Crystal Reports to get the information out of those memo fields. However, the ODBC connection that we created for her to be able to access the table does not show the table that contains the memo fields. Most other tables in the folder are visible, but the one in particular does not show up as an option to select to get the data from.
In doing some research, it seems that others have had similar issues with files that have cdx indexes. The solution that was posted was to make sure to have the latest Visual Fox Pro driver installed (we do, 6.01.8629.01) and then to uncheck the Null and Deleted options for the table. However, the result is still that the table that they want doesn't show up for them to select.
Any ideas or suggestions as to what I might be able to do to get this data available? We do not have any SQL servers or installations. Thanks in advance.