Re: Cannot connect to MS SQL 2008 server from OS X using FreeTDS

Google "freetds logging" and dump info about the connection using that info
to help diagnose the problem.

---------------------------------------------
Randy Syring (sent from my mobile)
Development & Executive Director
Level 12 Technologies
Direct: 502-276-0459
Office: 502-212-9913

Principled People, Technology that Works
On Apr 6, 2012 7:51 PM, "Paul Wuersig" <[email protected]> wrote:

> The basic error looks like so:
>
> $ tsql -H <hostname> -p 1433 -U <user>
> Password:
> locale is "en_US.UTF-8"
> locale charset is "UTF-8"
> using default charset "UTF-8"
> Error 20017 (severity 9):
>        Unexpected EOF from the server
>        OS error 36, "Operation now in progress"
> Error 20002 (severity 9):
>        Adaptive Server connection failed
> There was a problem connecting to the server
>
> This is identical to the error from using tsql to connect to *any* open
> port!
>
> Connecting with "-S <server> -U <user>", or connecting to any closed port,
> produces error 20009:
> Error 20009 (severity 9):
>        Unable to connect: Adaptive Server is unavailable or does not exist
>        OS error 61, "Connection refused"
>
> I can connect to the server just fine using MS SQL Server Management
> Studio on Windows XP.
>
> I've tried other MS-SQL servers, which produce the same errors.
>
> I've tried FreeTDS 0.82, 0.91, and freetds-0.92.dev.20120312 (latest).
> Same errors on all of them (although the errors are printed slightly
> differently in 0.82).
>
> I've tried 0.92 with "MS db-lib source compatibility" enabled, with the
> same results.
>
> The server has an entry in /usr/local/etc/freetds.conf. I've tried tds
> version 0, 5.0, 7.0, 7.1, 7.2, and 8.0, with the same results.
>
> I've Googled this extensively, and I've tried essentially all the things
> people have suggested for similar errors.
>
> This is on a Mac running 10.7.3.
>
> Suggestions, or things to try, or more information I can give that might
> prove fruitful, are all appreciated!
>
> Thanks,
> Paul
>
>
> -----------------------------------------------------------------------------------
> This email message is for the sole use of the intended recipient(s) and
> may contain
> confidential information.  Any unauthorized review, use, disclosure or
> distribution
> is prohibited.  If you are not the intended recipient, please contact the
> sender by
> reply email and destroy all copies of the original message.
>
> -----------------------------------------------------------------------------------
> _______________________________________________
> FreeTDS mailing list
> [email protected]
> http://lists.ibiblio.org/mailman/listinfo/freetds
>