[rhelv6-list] FreeTDS (UNCLASSIFIED)

[Van Bogart, Mark H Mr CIV NG MN ARNG]

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