I think I created a table without the field 'System_ID' when
first migrating from SQL 2000 to SQL 2005 and now I can not get CF
5.0 to refresh its view of SQL 2005.
I get the following error when running SQL 2005 and CF 5.0,
but have no problems when running SQL 2000 and CF 5.0 nor when
running SQL 2005 and CF 2008 trial version. If I delete the
'system_id' from the SELECT statement it works too.
I get the same error if I delete the table, or if I delete
the entire database. The only thing that causes other errors is
when I shut down the server or delete ODBC connection. I have
rebooted the entire server (Server 2003), shut down the SQL 2005 -
anything I could think of to clear buffers. The other thousand
lines of CF code and about 100 tables works fine and interfaces
nicely with a .NET application and Crystal Reports.
Short of spending $1200 to upgrade or renaming tables or
databases, does anyone an idea of how to get around this.
Thank you in advance,
Error Diagnostic Information
ODBC Error Code = S0022 (Column not found)
[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column
SQL = "select segment_id, segment_name, system_id from
Data Source = "GIS_CABLE_FAULT_2005"
The error occurred while processing an element with a general
identifier of (CFQUERY), occupying document position (13:1) to
(13:62) in the template file F:\TYSIMSCF\FAULTS.CFM.