OBDC authentication

Dick Bailey ( (no email) )
Thu, 17 Jul 1997 16:12:03 -0400

We were unable to get RadiusNT to run reliably as a service and we have
been using it in the dos -x15 mode. It was authenticating from the SQL
database that way. We upgraded to the 6.0 version of RadiusNT and get the
following error when we try to use ODBC. It is the same using it is a dos
application or a service. It works fine using it in text (users) mode. It
checks fine if we use the check function in radadmn. This is the error
message we get when authenticating from SQL.

Any suggestions?

--------

NAS-Port = 0
User-Name = "joe"
Password = "j\2106z\240i:U\357\377\376\320\333\240\202;"
rad_authenticate_ODBC()
Password = "j\2106z\240i:U\357\377\376\320\333\240\202;"
Decrypted Password: +¦?ª¯(l/¦»èn¦+7¦
Allocating Statement...

SQL Statement: Select DateAdd(Day, ma.extension, maExpireDate),
DateAdd(Day, sa
...extension, saExpireDate), sa.AccountID, sa.AccountType, sa.Password,
sa.Login,
sa.Shell, sa.LoginLimit From MasterAccounts ma, SubAccounts sa Where
(sa.Login='
osands' or sa.Shell='joe') AND ma.CustomerID=sa.CustomerID and sa.Active<>0
a
nd ma.Active<>0

LOG: ODBC: SQLExecDirect Error:
[Microsoft][ODBC SQL Server Driver]Connection is busy with results for
another
hstmt

ODBC: SQLExecDirect Error:
[Microsoft][ODBC SQL Server Driver]Connection is busy with results for
another
hstmt
Sending Reject of id 1 to c61e1611 (ntserv2)

Response Time: 110