ODBC Error

Gary Austin ( (no email) )
Sun, 2 Mar 1997 15:43:27 -0500

I have just came across an error that is puzzling. This id worked until
this morning. I have deleted this id completely and still get an error. I
shut the service down and restarted it but nothing. I ran radius with -x15
and got the following. I removed the password.

radrecv: Request from host d0054c04 code=1, id=242, length=77
User-Name = "jwalker"
Password = changed
NAS-Identifier = 208.5.76.4
NAS-Port = 3
NAS-Port-Type = Async
User-Service = Framed-User
Framed-Protocol = PPP
rad_authenticate_ODBC()
Password = changed
Decrypted Password: changed
Allocating Statement...

SQL Statement: Select DateAdd('d', ma.extension, maExpireDate),
DateAdd('d',
ma.extension, maExpireDate), sa.AccountID, sa.AccountType, sa.Password,
sa.L
ogin, sa.Shell From MasterAccounts ma, SubAccounts sa Where
(sa.Login='jwalke
r' or sa.Shell='jwalker') AND ma.CustomerID=sa.CustomerID and sa.Active<>0
an
d ma.Active<>0

ODBC: SQLFetch Error:-1: (22005)
[Microsoft][ODBC Microsoft Access 97 Driver] Data type mismatch in
criteria
expression.
Freeing SQL Statement...
Not Found in ODBC, Checking users file...
rad_authenticate()
rad_auth(): user_find(jwalker) error = Neither User Nor Default Name
LOG: Authenticate: from 208.5.76.4 - Neither User Nor Default Name: jwalker

Sending Reject of id 242 to d0054c04 (208.5.76.4)

Response Time: 203

I have other accounts that work fine. Any help would be appreciated.