[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