Re: [RadiusNT] ODBC: SQLExecDirect Error.

Jean Bou Issa ( (no email) )
Thu, 3 Jun 1999 13:20:24 +0300

here is the stored procedure that i created:

CREATE PROCEDURE RadCheckOnlineSNMP @UserName varchar(64) AS
Select s.IPAddress,,sp.SNMPUser From Servers s,ServerPorts sp
Where s.ServerID=sp.ServerID and UserName=@UserName and AcctStatusType=1

When i execute in isql_w i get the result:
IPAddress community SNMPUser
---------------- -------------------------------------------------- --------
------------------------------------------ public

-----Original Message-----
From: Dale E. Reed Jr. <>
To: <>
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
>Dale E. Reed Jr. Emerald and RadiusNT
>IEA Software, Inc.