Rita
-----Original Message-----
From: Dale E. Reed Jr. <daler@iea-software.com>
To: radiusnt@iea-software.com <radiusnt@iea-software.com>
Date: Thursday, June 03, 1999 5:52 PM
Subject: Re: [RadiusNT] SQL 7.0
>> 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