Skip to Content.
Sympa Menu

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

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "ZIGLIO, Frediano, VF-IT" <Frediano.Ziglio AT vodafone.com>
  • To: "FreeTDS Development Group" <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] Free TDS compiled ok but I can't connect
  • Date: Tue, 8 Jul 2008 09:49:43 +0200


> 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

Attachment: smime.p7s
Description: S/MIME cryptographic signature




Archive powered by MHonArc 2.6.24.

Top of Page