Skip to Content.
Sympa Menu

freetds - [freetds] tsql problem

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Rusty Wright <rusty AT socrates.Berkeley.EDU>
  • To: freetds AT lists.ibiblio.org
  • Subject: [freetds] tsql problem
  • Date: Wed, 12 Mar 2003 13:34:45 -0800 (PST)

I'm trying to connect to MS Sql server, version 8.00.760 (SP3), with
tsql. I'm able to connect to the sql server from my pc, where I
installed the Personal Edition, using osql. On my pc I use

osql -H servername -S servername -U rusty

and it prompts me for my password and I can get in and issue queries.

I've installed freetds on my Solaris box, on a SparcStation, and when
I try to connect to the same server I get the following:

tsql -H servername -U rusty -p 1433
locale is "C"
charset is "646"
Password:
Msg 18456, Level 14, State 1, Server , Line 0
Login failed for user 'rusty'.
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

When I compiled freetds I used the following configure options:

--with-tdsver=4.2
--enable-msdblib
--enable-sybase-compat

Any ideas why I can't connect with tsql?

Thanks




Archive powered by MHonArc 2.6.24.

Top of Page