0 Replies Latest reply on Sep 2, 2008 11:19 AM by Morristown

    SQL 2005 and CF 5.0

      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 name 'system_id'.

      SQL = "select segment_id, segment_name, system_id from Segment"

      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.

      Date/Time: 09/02/08 11:26:49
      Browser: Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 1.1.4322; .NET CLR 2.0.50727; InfoPath.1; .NET CLR 3.0.04506.648; .NET CLR 3.5.21022)
      Remote Address:
      HTTP Referrer: http://usy45ap0n/tysimscf/default.cfm