Re: [RadiusNT] ODBC: SQLExecDirect Error.
Dale E. Reed Jr. ( (no email) )
Thu, 03 Jun 1999 10:53:24 -0500
Jean Bou Issa wrote:
>
> here is the stored procedure that i created:
>
> CREATE PROCEDURE RadCheckOnlineSNMP @UserName varchar(64) AS
> Select s.IPAddress,s.community,sp.SNMPUser From Servers s,ServerPorts sp
> Where s.ServerID=sp.ServerID and UserName=@UserName and AcctStatusType=1
> GO
>
> When i execute in isql_w i get the result:
> IPAddress community SNMPUser
> ---------------- -------------------------------------------------- --------
> ------------------------------------------
> 192.168.199.1 public
> 192.168.199.1.4
Does whomever RadiusNT is connected as have access to the proc? The
SNMPUser string above is not correct, either. It should be an OID, not
an IP Address.
--
Dale E. Reed Jr. Emerald and RadiusNT__________________________________________IEA Software, Inc. www.iea-software.com