FreeTDS Development Group

[Randy Syring <rsyring AT gmail.com>]

Todd,

I have found TDSDUMP and TDSDUMPCONFIG to be invaluable when 
troubleshooting connection issues:

http://www.freetds.org/userguide/logging.htm

---------------------------------------------
Randy Syring
Development & Executive Director
Level 12 Technologies  <https://www.lev12.com/>
Direct: 502-276-0459
Office: 502-212-9913

Principled People, Technology that Works

On 10/09/2012 06:11 PM, Todd Brush wrote:
> Unfortunately I see limited troubleshooting documentation related to my
> specific problem within the document you referenced. When I check externals
> sources, I find conflicting information, and references to various config
> files that reference each other. I do not understand why this is so
> convoluted!
>
> In testing, tsql works sometimes, and osql does not, then I change a
> configuration and test again, and not tsql does not work at ALL, and osql
> output is further along, but still not successful. Frustration.
>
>
> Please tell me what log files or config files I can send to shed light on
> where I am obviously going wrong. I am trying to connect from a SUSE Linux
> vm to MS SQL 2005 [Microsoft SQL Server 2005 - 9.00.4060.00 (X64)   Mar 17
> 2011 13:06:52   Copyright (c) 1988-2005 Microsoft Corporation  Enterprise
> Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 2]
>
> Again, using the (now expired) Easysoft driver, I was able to set this up
> in minutes and use their isql tool to run queries from a bash shell, from
> the exact same vm to the exact same sql server. The problem must lie within
> my freeTDS and or unixODBC configuration. It's not a network/protocol or
> credentials/permissions issue.
>
>
>
> On Sat, Oct 6, 2012 at 2:04 PM, James K. Lowden <jklowden AT freetds.org>wrote:
>
> > On Fri, 5 Oct 2012 16:18:17 -0400
> > Todd Brush <brush.todd AT gmail.com> wrote:
> >
> > > #cat /usr/local/etc/odbc.ini
> > > [NICKNAME]
> > > Driver=FreeTDS
> > > Description=mssql driver
> > > Server=hostname.dnssuffix.com
> > > Port=1433
> > > User=domain\username
> > > Password=password
> > > Database=DBNAME
> > http://www.freetds.org/userguide/odbcconnattr.htm
> >
> > Please read that document again.  Some of what is in your odbc.ini is
> > not read by the driver; extra entries are silently ignored.
> >
> > Remember that specifying "Server" (not "Servername) in odbc.ini lets
> > the driver connect without reference to freetds.conf.  osql will show
> > you that.
> >
> > I suspect what's missing is the TDS version.  You don't say how you
> > configured FreeTDS or what kind of server you're connecting to.  If you
> > didn't change the defaults and you're connecting to a Microsoft server,
> > it won't work!
> >
> > Two other tools at your disposal: osql and TDSDUMP.
> >
> > HTH.
> >
> > --jkl
> > _______________________________________________
> > FreeTDS mailing list
> > FreeTDS AT lists.ibiblio.org
> > http://lists.ibiblio.org/mailman/listinfo/freetds
> _______________________________________________
> FreeTDS mailing list
> FreeTDS AT lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds