Skip to Content.
Sympa Menu

freetds - RE: query on tsql to use hostname

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: ZIGLIO Frediano <Frediano.Ziglio AT vodafoneomnitel.it>
  • To: "'TDS Development Group'" <freetds AT franklin.metalab.unc.edu>
  • Subject: RE: query on tsql to use hostname
  • Date: Mon, 19 Aug 2002 15:14:46 +0200


>
> I am trying to use the tsql utility that comes with the freeTDS
>

What version of freetds are you using ?

> MY scenario is like this
> I have MS SQL 2000 running on my network
> and I have freetds installed in RedHat 7.2 System
> if I try
> [root@localhost bin]# ./tsql -Sccr3mcg109 -H172.18.57.40
> -p1433 -Usa -Pgnu

There are too options...

> I am able to connect and able to query
> well now if i try with the host name
>
> [root@localhost bin]# ./tsql -Sccr3mcg109 -Usa -Pgnu
> Unknown marker: 0!!
> There was a problem connecting to the server
>
> My entry in the /usr/local/freetds/
> [ccr3mcg109]
> host=172.18.57.40
> port = 1433
> tds version = 7.0
> try domain logins = no
> try server logins = yes

I don't know if this is a documentation problem or error in freetds.conf
example but should be (or just remove these line)
try domain login = no
try server login = yes

> nt domain = ccr

Useless with server login.

>
> I looked up the /tmp/freetds.log
>
> 2002-08-19 12:19:47 Connecting addr 172.18.57.40 port 1433
> 2002-08-19 12:19:47 inside tds_process_login_tokens()
> 2002-08-19 12:19:47 inside tds_process_default_tokens() marker is 0
>
> Can you tell me where I have made a mistake in the
> freetds.conf file entry .
>
>
> Cheers and Regards
> Abhilash
>
It sound correct for server login.
Is password correct?
Can you post a trace (with ethereal or tcpdump) with a less powerfull
password (create a test account)

freddy77

=================================
"STRICTLY PERSONAL AND CONFIDENTIAL

This message may contain confidential and proprietary material for the sole
use of the intended recipient. Any review or distribution by others is
strictly prohibited. If you are not the intended recipient please contact
the sender and delete all copies.
The contents of this message that do not relate to the official business of
our company shall be understood as neither given nor endorsed by it."

=================================




Archive powered by MHonArc 2.6.24.

Top of Page