Question
Report Wrtier, Visual FoxPro
I'm running CF MX 7.01, Visual FoxPro 9.0 SP1 on my local
machine.
When I attempt to run the "Report Creation Wizard" in Report Writer and select the "Query Builder", then select a table option I get the error:
ColdFusion Report Builder
An Error occurred retrieving table fields from table (cmf): [Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Visual FoxPro Driver]Invalid column number
I get the same error on any VFP table I attempt to connect to regardless of the database.
Report Writer works fine with Access tables.
The ODBC connection to this database works fine with CF MX. I can select, Insert.
The ODBC is set as a “System DSN” pointing at a single VFP database, not free tables.
I can find no errors in the database or any of the tables using VFP.
If I answer the message, click “OK” twice, then the table will appear with only the select all fields, “*”.
When I attempt to run the "Report Creation Wizard" in Report Writer and select the "Query Builder", then select a table option I get the error:
ColdFusion Report Builder
An Error occurred retrieving table fields from table (cmf): [Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Visual FoxPro Driver]Invalid column number
I get the same error on any VFP table I attempt to connect to regardless of the database.
Report Writer works fine with Access tables.
The ODBC connection to this database works fine with CF MX. I can select, Insert.
The ODBC is set as a “System DSN” pointing at a single VFP database, not free tables.
I can find no errors in the database or any of the tables using VFP.
If I answer the message, click “OK” twice, then the table will appear with only the select all fields, “*”.
AdChoices