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: "Thompson, Bill D (London)" <bill_d_thompson AT ml.com>
  • 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:16:27 -0000

Hi Andrew,

You need to configure your SQL server in the file freetds.conf (our
alternative to the sybase interfaces file)
The user guide should help you set this up.
Im guessing your SQL server 7 server is working because it is set up in the
sybase interfaces file ...

Bill



> -----Original Message-----
> From: Andrew McCall [SMTP: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

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

If you are not an intended recipient of this e-mail, please notify
the sender, delete it and do not read, act upon, print, disclose,
copy, retain or redistribute it.

Click here for important additional terms relating to this e-mail.
<http://www.ml.com/email_terms/>

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





Archive powered by MHonArc 2.6.24.

Top of Page