Hi to all!
I have some trouble with debian stable, iODBC and FreeTDS to connect with a MS
SQL server. I hate sql server but this is my first real job and i can't say
no.
This is my problem: freeradius says
"sql_create_socket: SQLConnectfailed: [iODBC][Driver Manager]Data source name
not found and no default driver specified. Driver could not be loaded"
This is my /etc/odbc.ini
[ODBC Data Sources]
MSSQL = sql con connessione FreeTDS
[MSSQL]
Description = FreeTDS Freeradius MSSQL
# Driver = {FreeTDS}
Database = Radius_DB
Driver = /usr/lib/odbc/libtdsodbc.so
Setup = /usr/lib/odbc/libtdsS.so
UID = wireles_admin
PWD = ***
Port = 1433
Server = 192.168.1.21
TDS Version = 8.0
[Default]
Driver = /usr/lib/odbc/libtdsodbc.so
Setup = /usr/lib/odbc/libtdsS.so
When i try
iodbctest "DSN=MSSQL;UID=wireless_admin;PWD=***"
from command line everithing works well and i can query my db.
If i try
iodbctest "DSN=MSSQL"
i have this error
1: SQLDriverConnect = [FreeTDS][SQL Server]Could not find UID parameter (0)
SQLSTATE=IM007
1: ODBC_Connect = [FreeTDS][SQL Server]Could not find UID parameter (0)
SQLSTATE=IM007
I have the ODBCINI set to /etc/odbc.ini
Can anyone help me?
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
