Access ODBC Errors

Tony ( tony@bcc.cc.tx.us )
Wed, 06 May 1998 11:01:01 -0500

We are getting errors authenicating to an Access database w/portmaster2
here is the Debug.
We removed the primary keys in the Calls Table and it started to work,
But we are looking
for the real reason/cure for this problem

C:\radius>radius -x15 -o

RadiusNT 2.2.41 7/27/97 Copyright (c) 1996-1997 IEA Software, Inc.
All Rights Reserved, Worldwide

Some portions Copyright (c) 1992 Livingston Enterprises, Inc.
and Copyright (c) 1995 Ascend Communications, Inc.

0) Mode: 1
1) EncryptPasswords: 0
2) IgnoreCase: 1
3) ReqAcctAuth: 0
4) Options: 67
5) Debug: 15
6) ODBCDatasource: Radius
7) DataDirectory: c:\radius
8) AcctDirectory: c:\radius\acct
9) UsersFile: Users
10) Username:
11) Password:
12) CompanyName:
13) License:
14) AuthPort: 1645
15) AcctPort: 1646

Param: Debug Level: 15
Param: ODBC Only Enabled
Initializing Winsock...
ODBC Datasource: 'Radius'...
Making ODBC Connection...
MS Access Mode Enabled
Licensed MBRs: 200
Allocating Statement...

SQL Statement: Select Name, RadAttributeID, Type From RadAttributes

SQL Statement: Select ra.Name, rv.Name, rv.Value From RadValues rv,
RadAttribut
es ra Where rv.RadAttributeID = ra.RadAttributeId

SQL Statement: Select Server, IPAddress, Secret From Servers

4 Clients Loaded
20 Accounting Columns Loaded

Radius NT is ready to receive requests!
radrecv: Request from host a835b404 code=4, id=2, length=90
Acct-Session-Id = "7B000000"
User-Name = "tony"
NAS-IP-Address = 168.53.180.4
NAS-Port = 0
NAS-Port-Type = Async
Acct-Status-Type = Start
Acct-Authentic = RADIUS
User-Service = Framed-User
Framed-Protocol = PPP
Framed-Address = 168.53.180.10
Acct-Delay-Time = 843

SQL Statement: INSERT INTO Calls
(CallDate,AcctSessionId,UserName,NASPort,NASPo
rtType,AcctStatusType,AcctAuthentic,UserService,FramedProtocol,FramedAddress,Acc

tDelayTime) VALUES
(Now(),'7B000000','tony',0,0,1,1,2,1,'168.53.180.10',843)

ODBC: SQLExecDirect Error -1053:
[Microsoft][ODBC Microsoft Access 97 Driver] Index or primary key can't
contain
a Null value.

Resp Time: 90 Auth: 0/0 -> 0 Acct: 0/1/0 -> 1
radrecv: Request from host a835b404 code=4, id=2, length=90
Acct-Session-Id = "7B000000"
User-Name = "tony"
NAS-IP-Address = 168.53.180.4
NAS-Port = 0
NAS-Port-Type = Async
Acct-Status-Type = Start
Acct-Authentic = RADIUS
User-Service = Framed-User
Framed-Protocol = PPP
Framed-Address = 168.53.180.10
Acct-Delay-Time = 843

SQL Statement: INSERT INTO Calls
(CallDate,AcctSessionId,UserName,NASPort,NASPo
rtType,AcctStatusType,AcctAuthentic,UserService,FramedProtocol,FramedAddress,Acc

tDelayTime) VALUES
(Now(),'7B000000','tony',0,0,1,1,2,1,'168.53.180.10',843)

ODBC: SQLExecDirect Error -1053:
[Microsoft][ODBC Microsoft Access 97 Driver] Index or primary key can't
contain
a Null value.

Resp Time: 71 Auth: 0/0 -> 0 Acct: 0/2/0 -> 2
^C