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