The error says pri key can't contain a null value. The actual data doesn't
contain the NASIdentifier.
Mike Kuzenko
NetDotCom Internet Services
330-369-3617
mikek@netdotcom.com
----------
> From: Hershcopf, Jason <jhershcopf@FurmanSelz.com>
> To: 'RadiusNT@emerald.iea.com'
> Subject: RE: access 97 error radiusnt v60
> Date: Monday, June 09, 1997 2:47 PM
>
> 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
> >
> >
>
> ----------------------------------------------------------
> RadiusNT Mailing List listserver@emerald.iea.com