0 Replies Latest reply on Oct 27, 2004 5:02 PM by 431898

    An exception occurred: 'ExecuteSQL'

    431898
      This code is running ok in Microsoft/IIS-4.0 with
      OO40 version 2.3.0.2.0 :

      oDb.Parameters.remove "Indicadores"
      oDb.Parameters.remove "Referencia"
      oDb.Parameters.remove "Erro"
      oDb.Parameters.remove "Media"
      oDb.Parameters.remove "Maxvalor"
      oDb.Parameters.remove "Cursor"

      oDb.Parameters.Add "Indicadores",cod_indic,1
      oDb.Parameters("Indicadores").ServerType = 2
      oDb.Parameters.add "Referencia",cod_periodo,1
      oDb.Parameters("Referencia").ServerType = 2
      oDb.Parameters.add "Erro",0,3
      oDb.Parameters("Erro").ServerType = 2
      oDb.Parameters.add "Media",0,3
      oDb.Parameters("Media").ServerType = 2
      oDb.Parameters.add "Maxvalor",0,2
      oDb.Parameters("Maxvalor").ServerType = 2
      oDb.Parameters.add "Cursor",Null,2
      oDb.Parameters("Cursor").ServerType = 102
                     
      oDb.ExecuteSQL("Begin pkg_SIAGE.PR_INDICADOR(:Indicadores,:Referencia,:Erro,:Cursor,:Media,:Maxvalor); End;")

      But when I run the same code, with same database and parameters in Microsoft/IIS-5.0 with
      OO40 version 9.0.1.4.3 I receive this error :

      Microsoft VBScript runtime error '800a01fb'

      An exception occurred: 'ExecuteSQL'

      /asp/siage_grafico.asp, line 138

      Line 138 is oDb.ExecuteSQL("Begin pkg_SIAGE.PR_INDICADOR(:Indicadores,:Referencia,:Erro,:Cursor,:Media,:Maxvalor); End;")

      Can anyone help me ?