FreeTDS Development Group

[Joffrey Pannequin <joffrey.pannequin AT laposte.net>]

Thanks for the answer

James K. Lowden wrote:

> Joffrey Pannequin <joffrey.pannequin AT laposte.net> wrote:
>  
>
> > 08:52:25.813214 Found conf file '/usr/local/freetds/etc/freetds.conf' 
> > (default). Reading section '172.30.0.47:1433'.
> >    
>
> This says you're trying to connect to a server whose name is
> '172.30.0.47:1433'.  That's a little unconventional.  Is it what you
> meant?  
>
>  
I know this is not a standard way to access the server (At  first I did 
not know about this kind of config in the file freetds.conf). But at the 
end of the tdsdumpconfig, freetds says that it guesses the ip adress and 
port.

08:52:25.818088 Setting 'ip_port' to 1433 as a guess.
08:52:25.870930 Parsed servername, now 172.30.0.47 on 1433.
08:52:25.871084 Setting 'dump_file' to '/tmp/freetds.log' from $TDSDUMP.

And it works in command line mode. So I don't think this is a problem.

> If so, your freetds.conf should look something like this:
>
> [172.30.0.47:1433]
> host = 172.30.0.47
> port = 1433
> tds version = 7.0
>
> Most people would choose a friendlier name, e.g.:
>
> [myserver]
> host = 172.30.0.47
> port = 1433
> tds version = 7.0
>
> and then connect to 'myserver'.  
>
> HTH.
>
> --jkl
>
> P.S.  There are days I'm very glad Bill Thompson wrote TDSDUMPCONFIG.  :-)
>
> _______________________________________________
> FreeTDS mailing list
> FreeTDS AT lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds
>