Re: SQL Concurrency Tables

Dale E. Reed Jr. ( (no email) )
Thu, 18 Jun 1998 14:13:26 -0700

Majordomo@essex1.com wrote:
>
> I have recently converted our Access97 over to SQL and have everything
> running fine except for turning on the non-concurrency.
> I have a program I wrote to keep Radius honest, it telnets into our
> portmasters and verifies who's on with who Radius thinks is on and updates
> the ServerPorts table accordingly. I'm still not up to speed with SQL but I
> have noticed that there is a view (or table?) called 'CallsOnline' as well
> as the 'ServerPorts' table. Which does RadiusNt (SQL mode) use for checking
> concurrency? I'm in the process of updating our monitor program to handle
> SQL and thought I'd double check before I got too far.

The CallsOnline view includes information from the ServerPorts table
among others. Your program should update the serverports table.

-- Dale E. Reed Jr.  (daler@iea-software.com)_________________________________________________________________       IEA Software, Inc.      |  RadiusNT, Emerald, and NT FAQs Internet Solutions for Today  |   http://www.iea-software.com