Re: FreeTDS, unixODBC, SUSE Linux -- help!
"James K. Lowden" <[email protected]>
| Newsgroups | gmane.comp.db.tds.freetds |
|---|---|
| Message-ID | <[email protected]> |
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