Skip to Content.
Sympa Menu

freetds - Re: [freetds] FreeTDS, unixODBC, SUSE Linux -- help!

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "James K. Lowden" <jklowden AT freetds.org>
  • To: freetds AT lists.ibiblio.org
  • Subject: Re: [freetds] FreeTDS, unixODBC, SUSE Linux -- help!
  • Date: Sat, 6 Oct 2012 14:04:24 -0400

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




Archive powered by MHonArc 2.6.24.

Top of Page