RE: access 97 error radiusnt v60

Hershcopf, Jason ( (no email) )
Mon, 9 Jun 1997 14:47:58 -0400

Try going into Access 97 and open up your database. Under tables select
Design Calls. Make the 1st five fields the primary key (NASIdentifier,
NASPort, AcctSessionId, AcctStatusType, CallDate). Save the changes and
you should be fine.

jason

>----------
>From: Mike[SMTP:mikek@netdotcom.com]
>Sent: Monday, June 09, 1997 2:42 PM
>To: radiusnt@emerald.iea.com
>Subject: access 97 error radiusnt v60
>
>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,FramedAdd
>ress
>) 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.
>
>TIA
>Mike K
>mikek@netdotcom.com
>NetDotCom Internet Services
>330-369-3617
>
> ----------------------------------------------------------
> RadiusNT Mailing List listserver@emerald.iea.com
>
>