[Emerald] ODBC

Ned TOhme ( ntohme@cyberia.net.lb )
Thu, 18 Feb 1999 09:46:02 +0200

We just download EMERALD 2.5 and went through the standard set-up.

When we start RadiusNT in DEBUG mode we get the following ODBC errors:
Has anone gotten this problem before (and resolve it)?
It seems it is ODBC related (BTW we are using ODBC Drivers 3.5 for SQl Server)

HELP!!!!

0) Mode: 1
1) IgnoreCase: 0
2) TrimName: 1
3) ReqAcctAuth: 0
4) AllowMalformed: 0
5) Proxy: 0
6) Options: 1007
7) Debug: 15
8) LogFile:
9) AcctLogFile:
10) ODBCDatasource: Emerald
11) Username: Administrator
12) Password: ad
13) AcctODBCDatasource:
14) AcctUsername:
15) AcctPassword:
16) DataDirectory: c:\Temp
17) AcctDirectory:
18) UsersFile: Users
19) CompanyName: NTIC
20) License:
21) IPAddress: All
22) AuthPort: 1645
23) AcctPort: 1646
24) SNMP: 0
25) TestDatabaseSecs:

Param: Debug Level: 15
Initializing Winsock...
ODBC Datasource: 'Emerald'...
Making ODBC Connection...
MS SQL Server Mode Enabled

SQL Statement: Select DISTINCT Company, LiscenseID From Liscenses

ODBC Datasource: 'Emerald'...
Making ODBC Connection...
MS SQL Server Mode Enabled

SQL Statement: Select DISTINCT Company, LiscenseID From Liscenses

ODBC Error:24000:0:
[Microsoft][ODBC SQL Server Driver]Invalid cursor state

D:\Emerald\Radius.exe: RadiusNT 100 Request Trial Mode.
RadiusNT 100 Request Trial Mode.

Allocating Statement...

SQL Statement: Select Name, RadAttributeID, Type, RadVendorID,
RadVendorType From Ra
dAttributes Order By RadVendorID, RadAttributeID

ODBC Error:00000:13895872:

SQL Statement: Select ra.Name, rv.Name, rv.Value From RadValues rv,
RadAttributes ra
Where rv.RadAttributeID = ra.RadAttributeID

ODBC Error:00000:13895872:

0 Dictionary Attributes Loaded...

SQL Statement: Select Server, IPAddress, Secret From Servers

ODBC Error:00000:13895872:

0 Clients Loaded
ccounting Column 0 (16): 'AcctSessionI
ccounting Column 1 (16): 'NASIdentifie
ccounting Column 2 (1): 'AcctStatusTyp
ccounting Column 3 (4): 'NASPort'
ccounting Column 4 (16): 'CallDate'
ccounting Column 5 (32): 'Username'
ccounting Column 6 (4): 'AcctDelayTime
ccounting Column 7 (4): 'AcctSessionTi
ccounting Column 8 (16): 'FramedAddres
ccounting Column 9 (4): 'AcctInputOcte
ccounting Column 10 (4): 'AcctOutputOc
ccounting Column 11 (1): 'AcctTerminat
ccounting Column 12 (1): 'NASPortType'
ccounting Column 13 (10): 'NASPortDNIS
ccounting Column 14 (15): 'CallerID'
ccounting Column 15 (32): 'ConnectInfo
ccounting Column 16 (4): 'ServerID'
ccounting Column 17 (4): 'AccountID'
ccounting Column 18 (1): 'Status'
19 Accounting Columns Loaded
onfig_init(): dict_valfind(Lifetime-In

RadiusNT Enterprise Initialized...

For more information about this list, including removal,
please see http://www.iea-software.com/maillist.html