[rhelv6-list] FreeTDS

Tilsley, Jerry M. jmtilsley at st-claire.org
Thu Aug 23 18:06:00 UTC 2012


The issue ended up being the TDS Version.  I had 7.1, it needed to be 8.0.  I have corrected this now tsql tests correctly.

Thanks all for the assistance.

> -----Original Message-----
> From: rhelv6-list-bounces at redhat.com [mailto:rhelv6-list-
> bounces at redhat.com] On Behalf Of Mark Montague
> Sent: Thursday, August 23, 2012 1:36 PM
> To: rhelv6-list at redhat.com
> Subject: Re: [rhelv6-list] FreeTDS
>
> On August 23, 2012 12:17 , "Tilsley, Jerry M." <jmtilsley at st-claire.org>
> wrote:
> > 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?
>
> Check /etc/freetds.conf, /etc/odbcinst.ini, and /etc/odbc.ini very carefully
> for errors.  If you're not sure you have everything exactly right, experiment a
> little.
>
> Are you using the correct TDS version for your server?  Try other versions,
> both lower and higher (e.g., by setting the TDSVER environment variable).
>
> Do the logs on the database server shed any light on the problem?
>
> Configure FreeTDS logging on your RHEL6 client, and see if any useful clues
> appear in the logs.  http://www.freetds.org/userguide/logging.htm
>
>
> --
>    Mark Montague
>    LSA Research Systems Group
>    University of Michigan
>    markmont at umich.edu
>
> _______________________________________________
> rhelv6-list mailing list
> rhelv6-list at redhat.com
> https://www.redhat.com/mailman/listinfo/rhelv6-list

________________________________

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.




More information about the rhelv6-list mailing list