iODBC FreeTDS troubles
    Angelo Compagnucci 
    emailvarie at davide.it
       
    Sat Sep 16 00:06:35 CEST 2006
    
    
  
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?  
    
    
More information about the Freeradius-Users
mailing list