NetTalk Central

NetTalk Web Server => Web Server - Ask For Help => Topic started by: kevin plummer on March 03, 2008, 12:19:48 AM

Title: SQL Server Login Window
Post by: kevin plummer on March 03, 2008, 12:19:48 AM

Hi All,

I have a small web app which allows users to login to different companies (diff MSSQL DB's).

I set my Glo:DBOwner in the WebHandler and everything works as I would expect - except... if I stop the web app or it dies and I restart it, users currently logged in if they click anything, up pops the SQL Server Login on my server. I can easily reproduce everytime in testing.

As everything is ticked "User must be logged in" I was expecting that the login screen would appear and force the user to login again and setup all the sessionvalues for the Glo:DBOwner again but it doesn't....

Anyone experience this problem before? Any work arounds? Is it just my wonky code?

Cheers,

Kevin

Title: Re: SQL Server Login Window
Post by: Alan Telford on March 03, 2008, 11:44:00 AM

I do something similar to you.
in WebHandler procedure, ProcessLink method, I first do a PROP:Disconnect, then I look up the ownername from the session queue, and open a table  in the database.

  myTableName{prop:disconnect}
  GLO:DbOwner = ThisNetWorker.gsv('glo:dbowner')
  myTableName{prop:logonscreen} = false
  open(mytablename)

It seems to work ok.
Alan

Title: Re: SQL Server Login Window
Post by: kevin plummer on March 03, 2008, 10:41:50 PM

Thanks Alan but for some reason I get a GPF at the prop:disconnect.

I ended up finding a workaround by checking for a blank glo:dbowner and repopulating it...

Cheers,

Kev