ODBC Error

Gary Austin ( (no email) )
Wed, 5 Mar 1997 18:59:14 -0500

I am reposting this since I don't know if the first post worked and haven't
heard anything yet.
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 =
NAS-Port = 3
NAS-Port-Type = Async
User-Service = Framed-User
Framed-Protocol = PPP
Password = changed
Decrypted Password: changed
Allocating Statement...

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

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

Sending Reject of id 242 to d0054c04 (

Response Time: 203

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