Re: radius & access 97

Mike ( (no email) )
Thu, 12 Jun 1997 09:20:14 -0400

Dale:

This pops up when the INSERT INTO Calls SQL statement runs.

I captured by redirecting all output to a txt file ie. radius -x15 -o -R27
> capture.txt

But the error message pops up in the console not redirected to the text
file.

Mike Kuzenko
NetDotCom Internet Services
330-369-3617
mikek@netdotcom.com

----------
> From: Dale E. Reed Jr. <daler@iea.com>
> To: RadiusNT@emerald.iea.com
> Subject: Re: radius & access 97
> Date: Thursday, June 12, 1997 3:21 AM
>
> Mike wrote:
> >
> > I'm getting this error:
> >
> > ODBC: SQLExecDirect Error:
> > [Microsoft][ODBC Microsoft Access 97 Driver] You can't add or change a
> > record because a related record is required in table 'Servers'.
> >
> > My Servers table has 3 fields "Server" "IPAddress" "Secret" with "lrs1"
in
> > "server" "208.4.210.63" in "IPAddress" and my secret in "Secret"
> >
> > Here's a capture from radius:
> >
> > SQL Statement: INSERT INTO Calls
> >
> >
(CallDate,AcctStatusType,AcctSessionId,UserName,NASIdentifier,NASPort,NASPor

> > tType,UserService,FramedProtocol,FramedAddress) VALUES
> > (Now(),1,'0000026583','mike','lrs1',1,0,2,1,'208.4.210.64')
> >
> > Sending Accounting Ack of id 7 to d004d23f (lrs1)
>
> Where do you get that error? I need to see the -x15 around, and
> including
> the error to see what its trying to do.
>
> --
> Dale E. Reed Jr. (daler@iea.com)
> _________________________________________________________________
> IEA Software, Inc. | RadiusNT, Emerald, and NT FAQs
> Internet Solutions for Today | http://www.emerald.iea.com
>
> ----------------------------------------------------------
> RadiusNT Mailing List listserver@emerald.iea.com