[rhelv6-list] FreeTDS (UNCLASSIFIED)
Van Bogart, Mark H Mr CIV NG MN ARNG
Mark.Vanbogart at us.army.mil
Thu Aug 23 14:32:45 UTC 2012
Classification: UNCLASSIFIED
Caveats: NONE
Yes, I'm using v0.82 on Red Hat Enterprise Linux Server release 6.3
(Santiago)
I only do read operations for generating reports at this time.
Here's my /etc/freetds.conf
[global]
# TDS protocol version
; tds version = 4.2
# Whether to write a TDSDUMP file for diagnostic purposes
# (setting this to /tmp is insecure on a multi-user system)
; dump file = /tmp/freetds.log
; debug flags = 0xffff
# Command and connection timeouts
; timeout = 10
; connect timeout = 10
# If you get out-of-memory errors, it may mean that your client
# is trying to allocate a huge buffer for a TEXT field.
# Try setting 'text size' to a more reasonable limit
text size = 64512
[srva4-ops-d1]
host = srva4-ops-d1.mydomain.com
port = 1433
tds version = 8.0
Here's my /etc/odbc.ini
[SRVA4-OPS-D1]
Description = MS SQL 2008
Driver = /usr/lib/libtdsodbc.so.0
ServerName = srva4-j6ops-d1
Port = 1433
Trace = Yes
TraceFile = /tmp/srva4-ops-d1_trace.log
ReadOnly = No
Here's my /etc/odbcinst.ini
# Example driver definitions
[TDS]
Description = v0.82 with protocol v7.0
Driver = /usr/lib/libtdsodbc.so
Driver64 =
Setup = /usr/lib/libtdsS.so
Setup64 =
UsageCount = 1
CPTimeout =
CPReuse =
Trace = Yes
TraceFile = /tmp/freetds.log
FileUsage = 1
Mark H. Van Bogart
Department of Military Affairs-J6
Phone: (651) 268-8824 DSN; 825-8824
Cell: (651) 324-2066
-----Original Message-----
From: rhelv6-list-bounces at redhat.com [mailto:rhelv6-list-bounces at redhat.com]
On Behalf Of Tilsley, Jerry M.
Sent: Thursday, August 23, 2012 9:09 AM
To: 'rhelv6-list at redhat.com'
Subject: [rhelv6-list] FreeTDS
All,
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.
Thanks,
Jerry Tilsley
Sr Systems Analyst/Interfaces
St. Claire Regional Medical Center
________________________________
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.
Classification: UNCLASSIFIED
Caveats: NONE
More information about the rhelv6-list
mailing list