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

elmalhi abdelghani eabdelghani at yahoo.fr
Tue Apr 24 05:42:17 EDT 2007


so i can use ping:

[root at Vigor238 ~]# ping 192.168.100.206
PING 192.168.100.206 (192.168.100.206) 56(84) bytes of data.
64 bytes from 192.168.100.206: icmp_seq=1 ttl=128 time=0.266 ms
64 bytes from 192.168.100.206: icmp_seq=2 ttl=128 time=0.255 ms
64 bytes from 192.168.100.206: icmp_seq=3 ttl=128 time=0.258 ms
64 bytes from 192.168.100.206: icmp_seq=4 ttl=128 time=0.243 ms

--- 192.168.100.206 ping statistics ---
4 packets transmitted, 4 received, 0% packet loss, time 3001ms
rtt min/avg/max/mdev = 0.243/0.255/0.266/0.018 ms

but telnet don´t work:
[root at Vigor238 ~]# telnet -d 192.168.100.206 1433
Trying 192.168.100.206...
telnet: connect to address 192.168.100.206: Connection refused
telnet: Unable to connect to remote host: Connection refused

with nslookup i have that:
[root at Vigor238 ~]# nslookup ENTWICKLUNG1
Server:         145.253.2.11
Address:        145.253.2.11#53

** server can't find ENTWICKLUNG1: NXDOMAIN

an other tipp welcom.
thinks

Daniel Fazekas <fdsubs at t-online.hu> a écrit : 
On Apr 23, 2007, at 17:25, elmalhi abdelghani wrote:

> [root at Vigor238 etc]# tsql -S 192.168.100.206 -p 1433 -U sa -P radius
> 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.

The translation widget says that German text means "Connection  
establishment rejected."

I think you'll find that even with telnet, you won't be able to  
connect to that IP address and port:
telnet 192.168.100.206 1433

So either that information is wrong, there's a firewall in the middle  
not allowing your connection to go through, or some network  
configuration problems prevent the two machines from talking to each  
other...

**

You have a lot of useless and misleading settings all over the place,  
but none of that has anything to do with this problem right now.

> [root at Vigor238 etc]# tsql -S 192.168.100.206 -p 1433 -U sa -P radius

The "-p" option is ignored if you use the -S switch, which expects a  
freetds.conf entry, and takes the rest of the settings from there.

> odbc.ini:
> [ENTWICKLUNG1]
> Driver = /usr/local/lib/libtdsodbc.so
> Description = Radius on ENTWICKLUNG1
> Trace = No
> Server = 192.168.100.206
> Port    =1433
> Database = radius

This way you are going to have an "ODBC-only configuration," ignoring  
the freetds.conf entry, and going with the default TDS version.
http://www.freetds.org/userguide/odbcinionly.htm

I'd recommend the "ODBC-combined configuration" myself, so you could  
have one global place for settings in freetds.conf:
http://www.freetds.org/userguide/odbcombo.htm

That would mean changing "Server = 192.168.100.206" above to  
"Servername = ENTWICKLUNG1" and removing the Port line entirely.

> odbcinst.ini:

None of this file will be used, since you already specified the full  
pathname of the freetds driver in odbc.ini.

> 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

Here I'd recommend removing the [192.168.100.206] section entirely,  
it could be rather confusing to have a FreeTDS entry name - which  
could be any arbitrary string of your choosing - look like an IP  
address.

Also bump the tds version to 8.0, since you said you were using SQL  
Server 2005.

Then you could do your tsql testing simply with:
tsql -S ENTWICKLUNG1 -U sa -P radius

> Version: freetds v0.63

It might also be a good idea to use a more recent version of freetds  
as well, if you are just at the process of setting it all up anyway.

> [root at Vigor238 etc]# isql ENTWECKLUNG1 sa radius
> [ISQL]ERROR: Could not SQLConnect

Note that you called it ENTWICKLUNG1, not ENTWECKLUNG1.

But again, none of the above after the "**" break really matters  
right now, if your machine cannot even connect to the given IP  
address and port number.

--
fds
_______________________________________________
FreeTDS mailing list
FreeTDS at lists.ibiblio.org
http://lists.ibiblio.org/mailman/listinfo/freetds



            Abdelghani ELMALHI
  Devesestr. 1
  45897 Gelsenkirchen
  Deutschland
Tel. 00 49 176 65 84 38 50







             
---------------------------------
 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