BusyHandling Error

[Alberto]

Hi,
PR37, C6.3 9058, MsSql express 2008
I´m Having serious errors running a web server and don't know what else to do.
All files are threaded.
All variables are threaded too.
Driver string in FM3 are set to /MULTIPLEACTIVERESULTSETS=TRUE
The errors happend only if I press the button in two different machines at the same time.
Tested in two diffrenet servers (Vista and Ws2003)
But I have a lot of busy handling and Cursor state errors running a code like:

   Access:apps_tmp.Open()
   Access:apps_tmp.UseFile()
   Access:apps_hrs.Open()
   Access:apps_hrs.UseFile()
   Access:Appointments.Open()
   Access:Appointments.UseFile()
   Access:CR_DAT.Open()
   Access:CR_DAT.UseFile()

   apps_tmp{prop:sql}='delete apps_tmp where id_user='&p_web.GetSessionValue('loc:IdUser')&' AND SESSION_ID='&p_web.SessionId&' '  ! the logged user
   !>>> ERROR <<<<

   !min and max hr in the week
   APPS_HRS{PROP:SQL}='SELECT 0,0,0,0,min(FROM_HR),max(TO_HR),min(BY_MINS) FROM APPS_HRS WHERE ID_MEDIC='&p_web.Gsv('loc:IdUser')&|
                      CHOOSE(p_web.gsv('loc:AppsFromClinic')<>0,' AND ID_CLINIC='&p_web.gsv('loc:AppsFromClinic')&' ','')&|
                      ' and FROM_DATE<='''&format(loc:inicd+7,@d6)&''' and TO_DATE>='''&format(loc:inicd,@d6)&''''
   !>>> ERROR <<<<
   
   next(APPS_HRS)
   if not error()
      if loc:DH>0 and loc:HH>loc:DH and loc:MM>0
         LOOP loc:H=loc:DH TO loc:HH BY loc:MM
            LOOP loc:d=loc:inicd TO loc:inicd+6
               !look for an appoinment for the cell
               Appointments{prop:sql}='select '&BUILDsELECTlIST(Appointments)&' from Appointments where ID_USER_to='&p_web.Gsv('loc:iduser')&|
                                      CHOOSE(p_web.gsv('loc:AppsFromClinic')<>0,' AND ID_CLINIC_TO='&p_web.gsv('loc:AppsFromClinic')&' ','')&|
                                      ' AND TO_DATE='''&format(loc:d,@d6)&''' '&|
                                      ' AND '''&APM:HR&''' BETWEEN FROM_TIME AND TO_TIME'
                                      !' AND FROM_TIME BETWEEN '''&APM:HR&''' AND '''&APM:HR_TO&''''
               !>>> ERROR <<<
               NEXT(Appointments)
               IF NOT ERROR()
               else
            END
            Access:APPS_TMP.TryInsert()
         END
      end
   END

   Access:apps_tmp.Close()
   Access:apps_hrs.Close()
   Access:Appointments.Close()
   Access:CR_DAT.Close()

Any idea please!!
Thanks
Alberto

[kevin plummer]

Have you tested with MSSQL2005? If you get the same problems then try setting the connection busy as well as the MARS setting. If MSSQL2005 is ok then it must be something specific with 2008. Maybe the Express version does not allow MARS. In that case I would try testing on the developers edition of 2008 to try and narrow down the problem.

[Alberto]

Hi,
Same problem in Sql 2005
Thorically havisng Driver string in FM3 are set to /MULTIPLEACTIVERESULTSETS=TRUE
that manage the busihandling and MARS ...
If not ... how do I set it?

Thanks
Alberto

[Alberto]

Hi, more data, Sql express 2005 and 2008 does support MARS

[kevin plummer]

Try this

/BUSYHANDLING=2 /MULTIPLEACTIVERESULTSETS=TRUE

I had similar headaches but this did the trick for me.

[Bruce]

there's a thread in share knowledge on this topic.

Cheers
Bruce

[Alberto]

YES! Kevin, thanks.
That did the trick.

I will post it in the Share Knowledge forum.

Thanks
Alberto