I change "usersname" to "username" and I still getting the same error.
Any idea ?
I don't want any times restrictions on ServerAccess do I set Start time to 0
and Stop time to 1440
Thank's
Bruno Tremblay
-----Original Message-----
From: radiusnt-request@iea-software.com
[mailto:radiusnt-request@iea-software.com] On Behalf Of Dale E. Reed Jr.
Sent: Friday, May 22, 1998 1:43 PM
To: radiusnt@iea-software.com
Subject: Re: Calls Online
Bruno Tremblay wrote:
>
> I have some problemes with my calls online.
> All Other things appear to work fine.
>
> SQL Statement: UPDATE CallsOnline Set Usersname='XXXppp',AcctStatusType=2,
> CallDate=Now(), FramedAddress='XXX.XXX.XXX.XXX' WHERE
> NASIdentifier='XXX.XXX.XXX.XXX' and NASPort=8 AND (DateADD('s',
> 0-i.AcctDelayTime, i.CallDate) >= CallDate or CallDate IS NULL)
>
> ODBC Error:07001:-3010:
> [Microsoft][ODBC Microsoft Access 97 Driver] Too few parameters.
> Expected 2.
This error means one of the fields listed above doesn't match a
field in the CallsOnline query. Actually, this looks like a bug
in RadiusNT 2.5, since it should be "username", not "usersname".
You could modify the query to have the column named usersname for
now until we can release a correction for it.
> If someone can say me which value I need to use in table ServerAccess,
> StartTime and StopTime. Each time I tried to use that service I got tha
> error in logs : Server:Vserver9 (XXX.XXX.XXX.XXX) Port:15 (Time)
They are minutes past midnight. SO if the customer can logn 8am to
5pm, it would be Start: 480 and Stop: 1020 (17*60). RadiusNT understands
that a start time larger than a stop time means wrap midnight. So
reversing the numbers would mean the user could login from 5pm to
8am.
--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