(no subject)
Dale E. Reed Jr. ( (no email) )
Fri, 19 Jun 1998 14:36:53 -0700
Majordomo@essex1.com wrote:
>
> Hello Again;
> I have recently converted over from access to SQL and have noticed this
> error showing up in our log. It doesn't seem to cause any problems with
> Radius but I would like to know what is causing this. Do you have any ideas?
>
> SQL Statement: UPDATE CallsOnline Set
> Username='username',AcctStatusType=1, CallDate=GetDate(),
> FramedAddress='206.31.15.154' WHERE NASIdentifier='206.31.15.12' and
> NASPort=12 AND (DateAdd(Second, 0-delay, GetDate()) >= CallDate OR
> CallDate IS NULL)
>
> ODBC Error:S0022:207:
> [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'delay'.
You should install the trigger (redownload the radiusnt.sql script) and
turn off manual calls update (and manual service update). This
problem was fixed in RadiusNT 2.5.126, also.
> Radius is running great! Much better then with Access97.
Yeah, probably like night and day. Its interesting to watch a
problematic install go to a problem free install by just swapping
the database out. (Not that I am saying you had a problematic
install).
-- 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