[freetds] RE: MS SQL Server

Blackstone, J. David jdavid.blackstone at cingular.com
Mon Feb 14 15:30:13 EST 2005


  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
> 


More information about the FreeTDS mailing list