[freetds] Free TDS compiled ok but I can't connect

ZIGLIO, Frediano, VF-IT Frediano.Ziglio at vodafone.com
Tue Jul 8 03:49:43 EDT 2008


> Hi
> 
> I downloaded FreeTDS today and configured and installed with the  
> following
> 
> ./configure --prefix=/usr/local/freetds --enable-msdblib --with- 
> tdsver=8.0
> make
> sudo make install
> 
> Next I opened the freetds.conf file and edited the default MSSQL  
> setup to read (from memory)
> 
> [PMXDB]
> 	host = <name>.<domain>.com
> 	port = 1433
> 	user = <user>
> 	tds version = 8.0
> 

user here is ignored. Does telnet work ??

> Then I tried to do the tsql connect tests using
> 
> /usr/local/freetds/bin/tsql -H <name>.<domain>.com -p 1433 -U <user>
> 
> Which yeilds the following error:
> 
> Msg 18456, Level 14, State 1, Server , Line 0
> Login failed for user '<user>'.
> Msg 20002, Level 9, State -1, Server OpenClient, Line -1
> Adaptive Server connection failed
> There was a problem connecting to the server
> 
> Running /usr/local/freetds/bin/tsql -C yeilds
> 
> locale is "C"
> locale charset is "646"
> Compile-time settings (established with the "configure" script):
>                     Version: freetds v0.62.dev.20030804

0.62 ?? quite old...

>      MS db-lib source compatibility: yes
>           Sybase binary compatibility: no
>                                    Thread safety: yes
>                                       iconv library: yes
>                                       TDS version: 8.0
>                                                 iODBC: yes
>                                             unixodbc: no
> 
> The thing is, I know for a fact that the host and user are valid so  
> why can't I connect?
> 
> Any help appreciated
> 

freddy77
-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/x-pkcs7-signature
Size: 3129 bytes
Desc: not available
Url : http://lists.ibiblio.org/pipermail/freetds/attachments/20080708/eff289f5/attachment.bin 


More information about the FreeTDS mailing list