Skip to Content.
Sympa Menu

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

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: elmalhi abdelghani <eabdelghani AT yahoo.fr>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: [freetds] RE : Re: RE : Re: MSSQL 2005 +unixODBC +Freetds
  • Date: Mon, 23 Apr 2007 17:25:39 +0200 (CEST)


hello James,
"James K. Lowden" <jklowden AT freetds.org> a écrit : elmalhi abdelghani wrote:
> [root@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@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@Vigor238 etc]# isql ENTWECKLUNG1 sa radius
[ISQL]ERROR: Could not SQLConnect
and:
[root@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.




Archive powered by MHonArc 2.6.24.

Top of Page