Skip to Content.
Sympa Menu

freetds - [freetds] RE: 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] RE: MS SQL Server
  • Date: Mon, 14 Feb 2005 14:30:13 -0600

My thanks to Josh for showing me how to enable the log file. I have now
determined that tragically I have been given a port that is running a
webserver (or possibly XML-RPC server) instead of a real MS SQL server. I
mention this here only because someone might find it funny. :)

I'll come back if I need more help, but odds are, someone somewhere in our
organization will find out who knows what port this server is running on.

Thanks again,
J. David


> -----Original Message-----
> From: Blackstone, J. David
> Sent: Monday, February 14, 2005 11:48 AM
> To: 'freetds AT lists.ibiblio.org'
> Subject: 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] RE: MS SQL Server, Blackstone, J. David, 02/14/2005

Archive powered by MHonArc 2.6.24.

Top of Page