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: [email protected] [mailto:rhelv6-list- > [email protected]] On Behalf Of Mark Montague > Sent: Thursday, August 23, 2012 1:36 PM > To: [email protected] > Subject: Re: [rhelv6-list] FreeTDS > > On August 23, 2012 12:17 , "Tilsley, Jerry M." <[email protected]> > 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 > [email protected] > > _______________________________________________ > rhelv6-list mailing list > [email protected] > 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. _______________________________________________ rhelv6-list mailing list [email protected] https://www.redhat.com/mailman/listinfo/rhelv6-list
