FreeTDS Development Group

["Lukasz Szybalski" <szybalski AT gmail.com>]

try this: http://lucasmanual.com/mywiki/unixODBC

 see if you can ping the mssql server or double check the port its running on.

Lucas

On Sat, May 10, 2008 at 12:59 AM, Devinder Singh <devinbhullar AT gmail.com> 
wrote:
> Hi
>
> I cant seem to connec to MSSQL 2000
> radius:/usr/local/freetds/etc # tsql -H 192.168.1.9 -p 1433 -U sa -P
> password
> locale is
> "LC_CTYPE=en_US.UTF-8;LC_NUMERIC=C;LC_TIME=C;LC_COLLATE=C;LC_MONETARY=C;LC_MESSAGES=C;LC_PAPER=C;LC_NAME=C;LC_ADDRESS=C;LC_TELEPHONE=C;LC_MEASUREMENT=C;LC_IDENTIFICATION=C"
> locale charset is "UTF-8"
> Msg 20004, Level 9, State 0, Server OpenClient, Line 0
> Read from SQL server failed.
> Msg 20014, Level 9, State 0, Server OpenClient, Line 0
> Login incorrect.
> There was a problem connecting to the server
>
> This is my freetds,conf
> # A typical Microsoft SQL Server 7.0 configuration
> ;[MyServer70]
> ;       host = ntmachine.domain.com
> ;       port = 1433
> ;       tds version = 7.0
>
> # A typical Microsoft SQL Server 2000 configuration
> ;[MyServer2k]
> ;       host = ntmachine.domain.com
> ;       port = 1433
> ;       tds version = 8.0
>
> # A typical Microsoft SQL Server 6.x configuration
> ;[MyServer65]
> ;       host = ntmachine.domain.com
> ;       port = 1433
> ;       tds version = 4.2
>
> [DELL-SERVER]
>        host = 192.168.1.9
>        port = 1433
>        tds version = 8.0
> "freetds.conf" 120L, 3638C
>
> Anything that i am missing
>
> I have alo unixodbc installed
>
>
> Devinder
>
>
>
>
> --
> Devinder
> _______________________________________________
> FreeTDS mailing list
> FreeTDS AT lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds
>



-- 
Automotive Recall Database. Cars, Trucks, etc.
http://www.lucasmanual.com/recall/
TurboGears Manual-Howto
http://lucasmanual.com/pdf/TurboGears-Manual-Howto.pdf