[prev in list] [next in list] [prev in thread] [next in thread] 

List:       freetds
Subject:    Re: [freetds] ODBC Connection problem
From:       "shiv kumar" <shivblore2000 () gmail ! com>
Date:       2006-09-21 15:14:35
Message-ID: 5e2cc4050609210802w5db07fe8ka9eb0fa810e2a27d () mail ! gmail ! com
[Download RAW message or body]

Thanks James,
The TDSERVER env variable was not set, this is the problem.

Date: Thu, 21 Sep 2006 10:02:24 -0400
From: "Lowden, James K" <james.k.lowden@alliancebernstein.com>
Subject: Re: [freetds] ODBC Connection problem
To: "FreeTDS Development Group" <freetds@lists.ibiblio.org>
Message-ID:
       <3778FAB3D61A7A40833F1CB3B8C173AA054FCEE9@AC2KAMA0107.ac.lp.acml.com>
Content-Type: text/plain;       charset="us-ascii"
> From: shiv kumar
> Sent: Thursday, September 21, 2006 9:07 AM
>
> I have installed the FreeTDS(0.63 ) and Unix ODBC(2.2.11) over our
> Solaris machine. When I tried to connect the SYBASE server using
> isql, it is throwing me the following error.
...
> ask@logan:UODBC> cat ./etc/odbc*.ini
                            ^^^^^^^^^
       The '*' makes it unclear what the real name of the file is, and
       the relative path makes it unclear where it is.

> [SASA]
> Driver          = FreeTDS
                   ^^^^^^^  No, should be the .so e.g.:
 Driver          = /export/home/ask/TDS/lib/libtdsodbc.so

> Description             = Test Sybase Database with FreeTDS
> Trace           = No
> Server          = 172.25.8.135
> Port            = 4100
> TDS Version      = 5.0
    ^ should be TDS_Version, note underscore.

> Database                 = shiv_1
>
> [FreeTDS]
> Description             = v0.63 with protocol v8.0
> Driver          = /export/home/ask/TDS/lib/libtdsodbc.so
> UsageCount              = 1

A TDSDUMP log would show any authentication problems.  If none is
created, it's because the driver wasn't called, which normally means
odbc.ini isn't set up correctly.  You can also verify your login with
tsql.

> I have installed the FreeTDS in non roort directory i.e., not in
> /usr/local directory. Will this is a problem?

No.  The software doesn't care where it is or who owns it.  Normal
installation sets permissions correctly.

HTH.

--jkl
_______________________________________________
FreeTDS mailing list
FreeTDS@lists.ibiblio.org
http://lists.ibiblio.org/mailman/listinfo/freetds
[prev in list] [next in list] [prev in thread] [next in thread]