Skip to Content.
Sympa Menu

freetds - SOLVED - RE: [freetds] Problem connecting to MS SQL Server 2000 f rom Linux

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Andrew McCall <Andrew.McCall AT ex.oldham.gov.uk>
  • To: 'FreeTDS Development Group' <freetds AT lists.ibiblio.org>
  • Subject: SOLVED - RE: [freetds] Problem connecting to MS SQL Server 2000 f rom Linux
  • Date: Fri, 19 Mar 2004 13:57:38 -0000

**********************************************************************
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,

Thanks for the replies. I added my server to the freetds.conf file and
specified the file from the command like. Although it didn't work, the
debug log contained more info this ime and showed that FreeTDS was trying to
connect to the server . rather than the IP address of the SQL server.

Upon further investigation it turned out that the administrator who built
the SQL server didn't add it to the DNS because WINS did everything he
needed..... at which point I walked off politely :)

I have added it to the DNS and I can now log in fine now.

Thanks,

-----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



  • SOLVED - RE: [freetds] Problem connecting to MS SQL Server 2000 f rom Linux, Andrew McCall, 03/19/2004

Archive powered by MHonArc 2.6.24.

Top of Page