> 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,'208.4.210.64')
>
> 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.
Dale