[freetds] MS SQL Server

Blackstone, J. David jdavid.blackstone at cingular.com
Mon Feb 14 12:47:46 EST 2005


  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


More information about the FreeTDS mailing list