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
-----Original Message-----
From: Dale E. Reed Jr. <daler@iea-software.com>
To: radiusnt@iea-software.com <radiusnt@iea-software.com>
Date: Wednesday, June 02, 1999 9:51 PM
Subject: Re: [RadiusNT] ODBC: SQLExecDirect Error.
>> Jean Bou Issa wrote:
>>
>> I have enabled the SNMP concurrency check, I added the fields
>> Community and SNMPUser to the tables Servers and ServerPorts
>> respectively.
>> i created a stored Procedure RadCheckOnlineSNMP.
>
>Please include the stored proc you created. There is an example
>one in the RadiusNT Docs.
>
>> But when Authenticating the Folllowing message appear:
>>
>> SQL Statement: RadCheckOnlineSNMP 'testtt'
>
>What happens if you execute that stored proc just like above in
>isql_w?
>
>
>--
>
>Dale E. Reed Jr. Emerald and RadiusNT
>__________________________________________
>IEA Software, Inc. www.iea-software.com
>