Skip to Content.
Sympa Menu

freetds - RE: [freetds] MS SQL Server

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Paparo, Joshua" <Joshua.Paparo AT bankofamerica.com>
  • To: "FreeTDS Development Group" <freetds AT lists.ibiblio.org>
  • Subject: RE: [freetds] MS SQL Server
  • Date: Mon, 14 Feb 2005 17:59:05 -0000

Hi J. David,

The first thing I did was to build sqsh with the modifications mentioned
at http://www.freetds.org/userguide/software.htm#SQSH

Then I enabled logging by putting a "dump file" entry in my freetds.conf
file. This will give your plenty of output.

I am also using SQL Sever 2000 and therefore set my TDS version to 8.0
in my conf file.

If you want DBD::Sybase to work you'll need to compile that module with
your SYBASE env variable set to your freetds install area and go from
there.

Josh




-----Original Message-----
From: freetds-bounces AT lists.ibiblio.org
[mailto:freetds-bounces AT lists.ibiblio.org] On Behalf Of Blackstone, J.
David
Sent: 14 February 2005 17:48
To: 'freetds AT lists.ibiblio.org'
Subject: [freetds] MS SQL Server

I am trying to connect to MS SQL Server with FreeTDS from Solaris. My
background is a Perl and Oracle programmer, so I am a little bit out of
my
league.

Initially I had been trying to use DBD::Sybase. When that did not
work, I
tried unixODBC and sqsh, each of which seemed to have the same problem.

Finally I have discovered tsql (mentioned in the FAQ) hidden in my
/usr/local/freetds/bin directory. I presume this is the right tool I
need
to use to try to isolate the problem and minimize the possibility that
my
problems could be from other tools such as DBD::Sybase.

I am using FreeTDS version 0.62.4. I did not add any options to
configure
other than to build the unixODBC driver and install in
/usr/local/freetds.
I have tried multiple TDS protocol versions, even those not expected to
work
with MS SQL server. None seem to work. I always seem to get an
"unknown
marker" error, although some tools additionally report a "Login
incorrect"
error.

The SQL Server admins report that the version number is 8.00.760,
although
they included a screenshot showing a "File version" of 2000.80.760.0. I
presume this means I am dealing with SQL Server 2000. I note that the
"Configurations that work" section of the user manual reports TDS
version
4.2 and 7.0 working for my setup
(http://www.freetds.org/userguide/configurations.htm), but they don't
seem
to work in this case.

My first question is this. Given a commandline of the following form:

TDSVER=x.x tsql -H 10.x.x.x -p xxxx -U username

.. what should I set TDSVER to in order to expect tsql to be able to
connect?

Second, now that I am trying to use tsql for debugging, it seems to
hang
forever, or else is using a very long timeout. How can I get more
verbose
output from this tool for sharing with this list so I can beg for more
help?

Thanks for any help that can be provided,
J. David
_______________________________________________
FreeTDS mailing list
FreeTDS AT lists.ibiblio.org
http://lists.ibiblio.org/mailman/listinfo/freetds



Notice to recipient:
The information in this internet e-mail and any attachments is confidential
and may be privileged. It is intended solely for the addressee. If you are
not the intended addressee please notify the sender immediately by telephone.
If you are not the intended recipient, any disclosure, copying, distribution
or any action taken or omitted to be taken in reliance on it, is prohibited
and may be unlawful.

When addressed to external clients any opinions or advice contained in this
internet e-mail are subject to the terms and conditions expressed in any
applicable governing terms of business or client engagement letter issued by
the pertinent Bank of America group entity.

If this email originates from the U.K. please note that Bank of America,
N.A., London Branch, Banc of America Securities Limited and Banc of America
Futures Incorporated are authorised and regulated by the Financial Services
Authority.





Archive powered by MHonArc 2.6.24.

Top of Page