Skip to Content.
Sympa Menu

freetds - RE: [freetds] Problem connecting to MS SQL Server 2000 from Linux

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Steve Hanselman <SteveH AT brendata.co.uk>
  • To: "'FreeTDS Development Group'" <freetds AT lists.ibiblio.org>
  • Subject: RE: [freetds] Problem connecting to MS SQL Server 2000 from Linux
  • Date: Fri, 19 Mar 2004 12:20:47 -0000

Check the port on your sql box (dos prompt, netstat -an, make sure it's
listening on 1433), on your UNIX box do a tcpdump to see what gets sent and
what is returned (initially I'd just do tcpdump -wz.z -s1500 -i
whateverintegerface host yoursqlserver and then do strings z.z).

Good starting point to tick off the ports and then see what gets sent.

Steve


-----Original Message-----
From: Andrew McCall [mailto:Andrew.McCall AT ex.oldham.gov.uk]
Sent: 19 March 2004 12:19
To: 'freetds AT lists.ibiblio.org'
Subject: [freetds] Problem connecting to MS SQL Server 2000 from Linux

**********************************************************************
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error you must delete
it and notify the system manager (e-mail: postmaster AT oldham.gov.uk).

This banner also confirms that this email message has been swept by
MIMEsweeper for the presence of computer viruses.

http://www.oldham.gov.uk
**********************************************************************

Hi Folks,

I am new to FreeTDS and unixODBC stuff, so if I have done something stupid
please excuse me! I am having problems connecting to Microsoft SQL Server
2000. After looking through the FreeTDS web site, I found that some
required info is version, so I am using MS SQL Server 7.0 and 2000, with
FreeTDS 0.62.1 along with unixODBC 2.2.8 under SuSE Linux 7.2 on Intel
hardware. ☺

I have compiled FreeTDS with these commands:

./configure --with-tdsver=8.0 --with-unixodbc=/usr/local/unixodbc/
--prefix=/usr/local/freetds-0.62.1
make
make install

I can connect to an MS SQL Server 7.0 with no problems as shown below :

# ./tsql -S sql-int.oldham.gov.uk -U phpbb locale is
"LC_CTYPE=en_GB@euro;LC_NUMERIC=C;LC_TIME=C;LC_COLLATE=C;LC_MONETARY=C;LC_ME
SSAGES=C;LC_PAPER=C;LC_NAME=C;LC_ADDRESS=C;LC_TELEPHONE=C;LC_MEASUREMENT=C;L
C_IDENTIFICATION=C"
locale charset is "ISO-8859-1"
Password:
1>

However when I try to connect to an MS SQL Server 2000 I get problems :

# ./tsql -S sql03.oldham.gov.uk -U phpbb2dev locale is
"LC_CTYPE=en_GB@euro;LC_NUMERIC=C;LC_TIME=C;LC_COLLATE=C;LC_MONETARY=C;LC_ME
SSAGES=C;LC_PAPER=C;LC_NAME=C;LC_ADDRESS=C;LC_TELEPHONE=C;LC_MEASUREMENT=C;L
C_IDENTIFICATION=C"
locale charset is "ISO-8859-1"
Password:
There was a problem connecting to the server

I have checked, and double checked the username and password so I am pretty
sure this isn’t the problem. If I set the TDSDUMPCONFIG=/tmp/tds.log I get
the following:

11:46:06.605553 Failed in reading conf file. Trying interface files.
11:46:06.605568 Looking for server sql03.oldham.gov.uk....
11:46:06.605695 Looking for server in /root/.interfaces.
11:46:06.605712 Searching interfaces file //root/.interfaces.
11:46:06.605734 Couldn't open /root/.interfaces.
11:46:06.605747 Looking for server in /etc/freetds/interfaces.
11:46:06.605760 Searching interfaces file /etc/freetds/interfaces.
11:46:06.605784 Couldn't open /etc/freetds/interfaces.
11:46:06.605797 Setting 'ip_port' to 1433 as a guess.
11:46:06.607598 tds_config_login:474: client_charset is ISO-8859-1.

There doesn’t seem Can anyone suggest why this could be happening?

Thanks,

Andrew McCall

_______________________________________________
FreeTDS mailing list
FreeTDS AT lists.ibiblio.org
http://lists.ibiblio.org/mailman/listinfo/freetds


The information contained in this email is intended for the personal and
confidential use
of the addressee only. It may also be privileged information. If you are not
the intended
recipient then you are hereby notified that you have received this document
in error and
that any review, distribution or copying of this document is strictly
prohibited. If you have
received this communication in error, please notify Brendata immediately on:

+44 (0)1268 466100, or email 'technical AT brendata.co.uk'

Brendata (UK) Ltd
Nevendon Hall, Nevendon Road, Basildon, Essex. SS13 1BX UK
Registered Office as above. Registered in England No. 2764339

See our current vacancies at www.brendata.co.uk




Archive powered by MHonArc 2.6.24.

Top of Page