At 03:45 PM 12/27/97 -0600, you wrote:
>Ok I have the account working fine (Thx to Mitch), I had to change the
>NASIdentifier to NASIPAddress, however the CallsOnline query is not
>working, and I understand that this has to work to enable concurency.
>
>John
>
>----------
>> From: Dale E. Reed Jr. <daler@iea.com>
>> To: RadiusNT@iea-software.com
>> Subject: Re: Accounting:Calls Table
>> Date: Saturday, December 27, 1997 8:55 AM
>>
>> Accounting wrote:
>> >
>> > Ok I am recv Acc packets, however there is one problem. When RadiusNT
>> > tries to insert data into the Calls Table it wont put the NASIdentifier
>in
>> > to the table and as this is part of the Primary Key and a part (i
>assume)
>> > of the CallsOnLine Query. Here is the SQL from RadiusNT as you can see
>> > there is no NASIdentifier or even an IPAddress to fill in to the
>> > NASIdentifier field thus the error.
>> >
>> > SQL Statement: INSERT INTO Calls
>> > (CallDate,UserName,NASPort,AcctStatusType,Acct
>> > DelayTime,AcctSessionId,AcctAuthentic,FramedProtocol,FramedAddress)
>VALUES
>> > (Now(
>> > ),'vivian',20110,1,18,'251993465',1,1,'209.16.226.104')
>> >
>> > ODBC: SQLExecDirect Error -1053:
>> > [Microsoft][ODBC Microsoft Access 97 Driver] Index or primary key
>can't
>> > contain
>> > a Null value.
>>
>> What does the accounting packet look like right above this that
>> you receive from the NAS? What kind of NAS do you have?
>>
>> --
>> Dale E. Reed Jr. (daler@iea.com)
>> _________________________________________________________________
>> IEA Software, Inc. | RadiusNT, Emerald, and NT FAQs
>> Internet Solutions for Today | http://www.iea-software.com
>>
>> ----------------------------------------------------------
>> RadiusNT Mailing List lists@iea-software.com
>
> ----------------------------------------------------------
> RadiusNT Mailing List lists@iea-software.com
>
>