Re: access 97 error radiusnt v60

Dale E. Reed Jr. ( (no email) )
Mon, 9 Jun 1997 12:15:57 -0700 ()

On Mon, 9 Jun 1997, Mike wrote:

> To any one:
> I'm attempting to setup RadiusNT v1.16.60 using Access 97.
> Below is the sql stmt and the error I'm getting.
> SQL Statement: INSERT INTO Calls
> (CallDate,AcctStatusType,AcctSessionId,AcctDel
> ayTime,UserName,NASPort,NASPortType,UserService,FramedProtocol,FramedAddress
> ) VA
> LUES (Now(),1,'00001D4FAD',2,'mike',1,0,2,1,'')
> ODBC: SQLExecDirect Error:
> [Microsoft][ODBC Microsoft Access 97 Driver] Index or primary key can't
> contain
> a Null value.
> From what I can determine the field NASIdentifier is part of the primary
> key of the calls table but the value is not being supplied by the sql
> insert statement.

What kind of NAS are you using? I'd like to see the -x15 debug
of the request right above where you clipped. This will show
what attributes you are receiving from the NAS. NASIdentifier
should ALWAYS be including in an Accounting Packet.