[rhelv6-list] FreeTDS

[Tilsley, Jerry M.]

All I have built a new box, added the repository stated below and followed the configuration examples below but I am still receiving the same error as:

tsql -S 10.1.212.106 -U <username>
Password:
locale is "en_US.UTF-8"
locale charset is "UTF-8"
using default charset "UTF-8"
Error 20002 (severity 9):
        Adaptive Server connection failed
There was a problem connecting to the server

There is no more detail than this.  Isql and osql fail as well.  Any ideas?

> -----Original Message-----
> From: Mark Montague [mailto:markmont at umich.edu]
> Sent: Thursday, August 23, 2012 10:27 AM
> To: Red Hat Enterprise Linux 6 (Santiago) discussion mailing-list
> Cc: Tilsley, Jerry M.
> Subject: Re: [rhelv6-list] FreeTDS
>
> On August 23, 2012 10:09 , "Tilsley, Jerry M." <jmtilsley at st-claire.org>
> wrote:
> > Has anyone successfully used FreeTDS with RHEL 6.x? I'm having trouble
> > getting it to work. Works great on RHEL 5.7, but neither of my RHEL
> > 6.x servers will work with it.
>
> I'm successfully using FreeTDS on two RHEL 6.3 systems to connect to a
> Microsoft SQL Server database via ODBC.
>
> I followed the instructions for setting up PHP PDO, ODBC, and FreeTDS to
> connect to MSSQL that are at
> http://www.php.net/manual/en/ref.pdo-odbc.php#98716
>
> Additional useful information is at
> http://lucasmanual.com/mywiki/unixODBC
>
> I enabled the EPEL repository on my systems and then ran "yum install
> freetds".
>
> I created a tds.driver file containing:
>
> [FreeTDS]
> Description = FreeTDS v0.91
> Driver64 = /usr/lib64/libtdsodbc.so.0
> Setup64 = /usr/lib64/libtdsS.so
>
> I created a tds.datasource file containing:
>
> [MY-DATABASE-TAG]
> Driver=FreeTDS
> Description=My Database Description
> Trace=No
> Server=mydatabase-server-fqdn.example.com
> Port=1433
> TDS Version=7.1
> Database=my_database_name
>
> I then ran:
>
> odbcinst -i -d -f tds.driver
> odbcinst -i -s -l -f tds.datasource
>
> At this point, I edited the files /etc/freetds.conf, /etc/odbcinst.ini,
> /etc/odbc.ini and made sure everything was correct. IMPORTANT:
> /etc/odbc.ini must have NO LEADING SPACES on any line, regardless of what
> you may see in examples in documentation.
>
> In /etc/freetds.conf, I have:
>
> [my-server-tag]
> host = mydatabase-server-fqdn.example.com
> port = 1433
> tds version = 7.1
>
> In /etc/odbc.ini I have the same stanza as in tds.datasource
>
> At this point, I was able to successfully test everything using both of these
> commands:
>
> osql -S MY-DATABASE-TAG -U 'my-ad-domain\my-username' -P 'password-
> goes-here' -I /etc
>
> isql -v MY-DATABASE-TAF 'my-ad-domain\myusername 'password-goes-
> here'
>
>
> I hope this helps.
>
> --
>    Mark Montague
>    LSA Research Systems Group
>    University of Michigan
>    markmont at umich.edu


________________________________

Disclaimer****
This email is confidential and intended solely for the use of the individual to whom it is addressed. Any views or opinions presented are solely those of the author and do not necessarily represent those of St. Claire Regional Medical Center. If you are not the intended recipient, be advised that you have received this email in error and that any use, dissemination, forwarding, printing or copying of the email is strictly prohibited. If you received this email in error please notify the St. Claire Regional Helpdesk by telephone at 606-783-6565.