in reply to ODBC problem

Actually - the important bit is the actual SQL statement that you try to run. Without knowing that it's unlikely that someone here will be able to tell why you get the "invalid cursor state" message.

Michael

Replies are listed 'Best First'.
Re^2: ODBC problem
by Win (Novice) on Nov 12, 2004 at 11:59 UTC
    The point at which I think that the stored procedure statement fails is about here:
    print 'UPDATE ICD_specifications_for_disease_ICD_9_ICD_10_calc_spec S +ET ICD_end_adjusted'; UPDATE ICD_specifications_for_disease_ICD_9_ICD_10_calc_spec SET ICD_ +end_adjusted = (ICD_end + '9') FROM ICD_specifications_for_disease_IC +D_9_ICD_10_calc_spec; if exists(select 1 from INFORMATION_SCHEMA.tables where table_name = +'Geo_mortality_count') begin raiserror ('Concurrent database access e +rror',1,1); GOTO start; end CREATE TABLE Geo_mortality_count ( Key_m INT IDENTITY, Cause VARCHAR(30) NULL, ICD INT NOT NULL, Output_Area VARCHAR(20) NULL, Sex NUMERIC NOT NULL, Age_start INT NULL, Age_end INT NULL, Age_range VARCHAR(10) NULL, Person_count NUMERIC DEFAULT '1' NOT NULL );
      This error message in conjuction with PRINT was discussed here.