Hello, The included db_mysql.sql which creates the MySQL schema required for FreeRADIUS created the radreply table with a two-character OP field (I assume for use with <=, >=, etc). It defaults to a single "=" and when I add a record, subsequent queries from a Microsoft SQL 2000 linked Database connection fail because it wants both characters filled (== maybe). We use Platypus as our billing system, which resides in the Microsoft SQL 2000 environment and talks to FreeRADIUS via the link mentioned above. Should I change the default to "==" or is there something else?
Here is the error: Server: Msg 7347, Level 16, State 1, Line 1 OLE DB provider 'MSDASQL' returned an unexpected data length for the fixed-length column '[FreeRADIUS]...[radreply].op'. The expected data length is 2, while the returned data length is 1. OLE DB error trace [Non-interface error: Unexpected data length returned for the column: ProviderName='MSDASQL', TableName='[FreeRADIUS]...[radreply]', ColumnName='op', ExpectedLength='2', ReturnedLength='1']. Cliff - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html