FreeTDS Development Group

[Todd Brush <brush.todd AT gmail.com>]

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
>