------=_NextPart_000_000C_01BEADC7.0653E090
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Hi,
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.
Can you help me?
Best regards
Rita
CREATE TABLE ServerAccess
(
ServerID int NOT NULL ,
Port int NULL FOREIGN KEY (ServerID, Port) REFERENCES =
ServerPorts(ServerID, Port) ,
AccountType varchar(15) NOT NULL REFERENCES AccountTypes(AccountType) =
CONSTRAINT pk_ServerAccess PRIMARY KEY (ServerID, Port, AccountType),
StartTime int NULL DEFAULT (0) ,
StopTime int NULL DEFAULT (0) ,
MaxSessionLength int NULL DEFAULT (0)=20
)
------=_NextPart_000_000C_01BEADC7.0653E090
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD W3 HTML//EN">
Hi,
my name is Rita Ruggeri and I'm using radiusNT 2.5, now it's working =via ODBC=20and all works well.
I've to transport radius under SQL microsof 7.0 and I'm in trouble =when I=20create serveraccess table: here port is NULL and Foreign Key and my sql =server=20gives me an error.
Can you help me?
Best regards
Rita
CREATE TABLE ServerAccess
(
ServerID int NOT NULL ,
Port int NULL FOREIGN KEY (ServerID, Port) REFERENCES =ServerPorts(ServerID,=20Port) ,
AccountType varchar(15) NOT NULL REFERENCES AccountTypes(AccountType) =CONSTRAINT pk_ServerAccess PRIMARY KEY (ServerID, Port, =AccountType),
StartTime int NULL DEFAULT (0) ,
StopTime int NULL DEFAULT (0) ,
MaxSessionLength int NULL DEFAULT (0)
)