[freetds] RE : Re: RE : Re: MSSQL 2005 +unixODBC +Freetds

elmalhi abdelghani eabdelghani at yahoo.fr
Mon Apr 23 11:25:39 EDT 2007


hello James,
"James K. Lowden" <jklowden at freetds.org> a écrit : elmalhi abdelghani wrote:
> [root at Vigor238 ~]# tsql -S ENTWICKLUNG1 -p 1433 -U sa -P root2007 
> locale is "de_DE.UTF-8"
> locale charset is "UTF-8"
> util.c:288:Starting log file for FreeTDS 0.64
>         on 2007-04-23 10:15:03 with debug flags 0x4fff.
> config.c:158:Attempting to read conf files.
> config.c:259:...$FREETDSCONF not set.  Trying $FREETDS/etc.
> config.c:275:...$FREETDS not set.  Trying $HOME.
> config.c:161:Failed in reading conf file.  Trying interface files.

This says you don't have (or can't read) /usr/local/etc/freetds.conf or
${HOME}.freetds.conf.  

Create one of those files.  See the User Guide for instructions.  

HTH.  

--jkl
so my files look as :
odbc.ini:
[ENTWICKLUNG1] 
Driver = /usr/local/lib/libtdsodbc.so 
Description = Radius on ENTWICKLUNG1 
Trace = No 
Server = 192.168.100.206
Port    =1433 
Database = radius 
odbcinst.ini:
[FreeTDS]
Description        = TDS driver
Driver        = /usr/local/lib/libtdsodbc.so
Driver64        = 
Setup        = /usr/local/lib/libtdsS.so
Setup64        = 
UsageCount        = 
CPTimeout        = 
CPReuse        = 
FileUsage        = 2

[default]
Description        = 
Driver        = /usr/local/lib/libtdsodbc.so
Driver64        = 
Setup        = /usr/local/lib/libtdsS.so
Setup64        = 
UsageCount        = 1
CPTimeout        = 
CPReuse        = 

freetds.conf:

[192.168.100.206]
    host = 192.168.100.206
    port = 1433
    tds version = 7.0
[ENTWICKLUNG1]
    host = 192.168.100.206
    port = 1433
    tds version = 7.0

so too:
[root at Vigor238 etc]# tsql -C
Compile-time settings (established with the "configure" script):
                           Version: freetds v0.63
                    MS db-lib source compatibility: yes
       Sybase binary compatibility: unknown
                     Thread safety: yes
                     iconv library: yes
                       TDS version: 7.0
                             iODBC: no
                          unixodbc: yes
I think the configuration is fine.
but:
[root at Vigor238 etc]# isql ENTWECKLUNG1 sa radius
[ISQL]ERROR: Could not SQLConnect
and:
[root at Vigor238 etc]# tsql -S 192.168.100.206 -p 1433 -U sa -P radius
locale is "de_DE.UTF-8"
locale charset is "UTF-8"
src/tds/login.c: tds_connect: 192.168.100.206:1433: Verbindungsaufbau abgelehnt
Msg 20009, Level 9, State 0, Server OpenClient, Line 0
Server is unavailable or does not exist.
There was a problem connecting to the server.

tipps or help ?
Regards.



             
---------------------------------
 Découvrez une nouvelle façon d'obtenir des réponses à toutes vos questions ! Profitez des connaissances, des opinions et des expériences des internautes sur Yahoo! Questions/Réponses.



More information about the FreeTDS mailing list