[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