Skip to Content.
Sympa Menu

freetds - [freetds] MS SQL Server

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Blackstone, J. David" <jdavid.blackstone AT cingular.com>
  • To: "'freetds AT lists.ibiblio.org'" <freetds AT lists.ibiblio.org>
  • Subject: [freetds] MS SQL Server
  • Date: Mon, 14 Feb 2005 11:47:46 -0600

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




Archive powered by MHonArc 2.6.24.

Top of Page