Re: OBDC authentication

Dale E. Reed Jr. ( (no email) )
Fri, 18 Jul 1997 17:15:19 -0700 ()

On Thu, 17 Jul 1997, Dick Bailey wrote:

> =09We were unable to get RadiusNT to run reliably as a service and we hav=
e
> 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 th=
e
> following error when we try to use ODBC. It is the same using it is a do=
s
> 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. =20
>=20
> Any suggestions?

There are two problems here:

> NAS-Port =3D 0
> User-Name =3D "joe"
> Password =3D "j\2106z\240i:U\357\377\376\320\333\240\202;"
> rad_authenticate_ODBC()
> Password =3D "j\2106z\240i:U\357\377\376\320\333\240\202;"
> Decrypted Password: +=A6?=AA=AF(l/=A6=BB=E8n=A6+7=A6

The first is that the decrypted password for the user is
garbage. That means there is a secret mis-match fot his
NAS.

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

This is a problem with the SQL Server ODBC 3.5 driver. You
installed IIS4b2 and it install that driver. Its beta and
broke. Install a 3.0 driver (www.microsoft.com/odbc) or
the 2.5 driver and it will work again. All applications
I tried against the 3.5 driver failed. =20

Dale