Re: FreeTDS, unixODBC, SUSE Linux -- help!
Randy Syring <[email protected]>
| Newsgroups | gmane.comp.db.tds.freetds |
|---|---|
| Message-ID | <[email protected]> |
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 <[email protected]>wrote: > >> On Fri, 5 Oct 2012 16:18:17 -0400 >> Todd Brush <[email protected]> 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 >> [email protected] >> http://lists.ibiblio.org/mailman/listinfo/freetds >> > _______________________________________________ > FreeTDS mailing list > [email protected] > http://lists.ibiblio.org/mailman/listinfo/freetds >