Re: [RadiusNT] SQL 7.0

Dale E. Reed Jr. ( (no email) )
Thu, 03 Jun 1999 10:51:53 -0500

> Rita Ruggeri wrote:
>
> my name is Rita Ruggeri and I'm using radiusNT 2.5, now it's working
> via ODBC and all works well.
>
> I've to transport radius under SQL microsof 7.0 and I'm in trouble
> when I create serveraccess table: here port is NULL and Foreign Key
> and my sql server gives me an error.

It should be:

CREATE TABLE ServerAccess
(
ServerID int NOT NULL REFERENCES Servers(ServerID),
Port int NULL,
AccountType varchar(15) NOT NULL REFERENCES AccountTypes(AccountType),
StartTime int NULL DEFAULT (0) ,
StopTime int NULL DEFAULT (0) ,
MaxSessionLength int NULL DEFAULT (0)
)
GO

I just updated the radiusnt.sql on the FTP site to correct this.

-- 

Dale E. Reed Jr.      Emerald and RadiusNT__________________________________________IEA Software, Inc.    www.iea-software.com