I had the same problem, You need to make sure that the "Extension" field
in the MasterAccounts has a value such as 0 for each user in the table. It
seems that a blank in this field will cause the ODBC call will fail.
cheers Warren
----------
> From: Samir R. Akhtar <srakhtar@ibisnet.net>
> To: radiusnt@iea.com
> Subject: Still can't get Radius to talk to Access...
> Date: Thursday, 28 November 1996 4:51
>
> I am now working with the most recent version of radius (.49) and am
> trying to get it to talk to the Access database. I have the servers
setup,
> including the local machine's IP for testing with radlogin, several
users,
> etc. I also have the system DSN for Radius set up.
> Radius starts up fine but cannot seem to authenticate any users in
> my tables. It keeps coming up with the following:
>
>
>
----------------------------------------------------------------------------
> --------------------
> radrecv: Request from host cf168b01 code=1, id=1, length=0
> NAS-Identifier = 127.0.0.1
> NAS-Port = 0
> User-Name = "test"
> Password = "\320]\222^\303\024\224^\015\273!J\012\201\345\334"
> rad_authenticate_ODBC()
> Password = "\320]\222^\303\024\224^\015\273!J\012\201\345\334"
> Decrypted Password: user
> Allocating Statement...
>
> SQL Statement: Select DateAdd('d', ma.extension, maExpireDate),
> DateAdd('d', ma
> .extension, maExpireDate), sa.AccountID, sa.AccountType, sa.Password,
> sa.Login,
> sa.Shell, sa.TimeLeft From MasterAccounts ma, SubAccounts sa Where
> sa.Login='tes
> t' AND ma.CustomerID=sa.CustomerID and sa.Active<>0 and ma.Active<>0
>
> ODBC: SQLFetch Error: (00000)
>
> Freeing SQL Statement...
> LOG: User: test Not found
>
> User: test Not found
> Sending Reject of id 1 to cf168b01 (ns1.ibisnet.net)
>
> Response Time: 47
>
----------------------------------------------------------------------------
> --------------------
>
> I did notice the ODBC: SQLFetch Error: (000000) but am not quite sure
> as to what it means?
> I realize that this is a free program, but I would really appreciate any
> assistance from
> others who have been more successful.
>
> Thanks in advance.
>
> Sam Akhtar
> -
> RadiusNT Mailing list (radiusnt@iea.com)
-
RadiusNT Mailing list (radiusnt@iea.com)