Re: ODBC Error:23000:-1053: Primary key cant contain null value

Dale E. Reed Jr. ( (no email) )
Tue, 19 May 1998 11:07:34 -0700

Jorge Pocaterra wrote:
>
> i'm running radiusNT 2.5.107 with a Computone PowerRack and a USR
> Totalcontrol, now everithing is running well with the Totalcontrol but when
> radius receives the stop record from the computone it gives me the following
> error
>
> ODBC Error:23000:-1053:
> [Microsoft][ODBC Microsoft access 97 driver] Index or index or primary key
> cant contain null value
>
> What could be wrong with the data base?
>
> I had the Powerrack working on an other radius server runing RadiusNT 1.49
> and it was working well.

You need to include the whole request (or atleast the whole SQL statement)
for us to detrmine more about the error. You can go into Access and
add a default value for each of the primary key fields and that should
help resolve most of these problems.

-- Dale E. Reed Jr.  (daler@iea-software.com)_________________________________________________________________       IEA Software, Inc.      |  RadiusNT, Emerald, and NT FAQs Internet Solutions for Today  |   http://www.iea-software.com