Skip to Content.
Sympa Menu

freetds - unixODBC woes, more details

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Leon Brooks <leon AT cclinic.com.au>
  • To: "TDS Development Group" <freetds AT franklin.oit.unc.edu>
  • Subject: unixODBC woes, more details
  • Date: Fri, 6 Sep 2002 12:56:53 +0800


Attached (and I'll post again inline if the list server balks) are an
obfuscated odbc.ini, odbcinst.ini and freetds.conf to check for gaffes. The
initials of the organisation have been replaced with XXX and the 3rd quad of
the internal addresses has been replaced with ??? to aid security.

192.168.???.130 is the main SQL server, 192.168.???.67 is a temporary test
server. Both are MS SQL Server 7.0.

sqsh will connect to either server via FreeTDS, unixODBC will connect through
the EasySoft bridge but not FreeTDS.

unixODBC isql can't find any DSNs at all.

The base system is Mandrake 8.1 unixODBC is 2.2.2, FreeTDS is 0.53.

Enlighten me! (-:

--
Computer Clinic (WA) P/L Lasting good health for your network!
+61-8-9207-3686 http://www.cclinic.com.au/

linux.conf.au 2003 The Australian Linux Technical Conference
http://conf.linux.org.au/ 22-25 January 2003 in Perth, Western Australia
#
# The freetds.conf file is a replacement for the original interfaces
# file developed by Sybase. You may use either this or the interfaces
# file, but not both.
#
# FreeTDS will search for a conf file in the following order:
#
# 1) check if a file was set programatically via dbsetifile() and
# is in .conf format, if so use that,
#
# 2) look in ~/.freetds.conf
#
# 3) look in @sysconfdir@/freetds.conf
#
# If FreeTDS has found no suitable conf file it will then search for
# an an interfaces file in the following order:
#
# 1) check if a file was set programatically via dbsetifile() and
# is in interfaces format, if so use that,
#
# 2) look in ~/.interfaces
#
# 3) look in $SYBASE/interfaces (where $SYBASE is an environment
# variable)
#
# Only hostname, port number, and protocol version can be specified
# using the interfaces format.
#
# The conf file format follows a modified Samba style layout. There
# is a [global] section which will affect all database servers and
# basic program behaviour, and a section headed with the database
# server's name which will have settings which override the global
# ones.
#

# Global settings, any value here may be overridden by a database
# server specific section
[global]
# TDS protocol version
tds version = 7.0

initial block size = 512

swap broken dates = no

swap broken money = no

# Database server login method, if both server and domain
# logins are enabled, domain login is tried first if a domain
# is specified, and if that fails the server login will be used.
try server login = yes
try domain login = no

# The default authentication domain, can be overridden by
# specifying a username with a domain prefix, e.g. DOMAIN\username
; nt domain = WORKGROUP

# If the server responds with different domain try that one?
cross domain login = no

# 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 level = 10

# Command and connection timeouts
; timeout = 10;
; connect timeout = 10;

# This is a Sybase hosted database server, if you are directly on the
# net you can use it to test.
;[JDBC]
; host = 192.138.151.39
; port = 4444
; tds version = 5.0

[TDSdev2]
host = 192.168.???.67
port = 1433
tds version = 7.0

# A typical Microsoft SQL Server 7.0 configuration
;[MyServer70]
; host = ntmachine.domain.com
; port = 1433
; tds version = 7.0

# A typical Microsoft SQL Server 7.0 configuration using domain logins
;[MyServer70]
; host = ntmachine.domain.com
; port = 1433
; tds version = 7.0
; try domain logins = yes
; try server logins = no
; nt domain = MYDOMAIN

# A typical Microsoft SQL Server 6.x configuration
;[MyServer65]
; host = ntmachine.domain.com
; port = 1433
; tds version = 4.2

;
; odbc.ini
;
; ODBC DSN configuration file
;
; This file is an OpenLink Software product configuration file.
; To learn more about this product, or any other product in our
; portfolio, please check out our web site at:
;
; http://www.openlinksw.com
;
; or contact us at:
;
; general.information AT openlinksw.com
;
; If you have any technical questions, please contact our support
; staff at:
;
; technical.support AT openlinksw.com
;
[ODBC Data Sources]
XXXBTEST = OpenLink SQL Server Lite Driver
XXXtest = Leon testing again
OpenLink = OpenLink (MT)
XXX2 = SQL Server
TDSdev2 = Developer2 pubs via FreeTDS
TDSxxxt = CIXXXB XXXTEST via FreeTDS
Doomed = Just another random test
Default = this sucks
DEFAULT = this really sucks

[TDSdev2x]
Driver = TDS
Description = Developer2 pubs via FreeTDS 1
Host = 192.168.???.67
ServerName = 192.168.???.67
ServerType = SQLServer 7
FetchBufferSize = 99
UserName = sa
UID = sa
Password = 7board
PWD = 7board
Database = pubs
ReadOnly = no
Trace = 1
TraceFile = /tmp/iodbc.trace

[TDSdev2]
Driver = /usr/lib/libtdsodbc.so
Description = Developer2 pubs via FreeTDS 1
Host = 192.168.???.67
ServerName = 192.168.???.67
ServerType = SQLServer 7
FetchBufferSize = 99
UserName = sa
UID = sa
Password = 7board
PWD = 7board
Database = pubs
ReadOnly = no
Trace = 1
TraceFile = /tmp/iodbc.trace

[Doomed]
Driver = /home/xxxstaff/ODBCbridge/lib/sql_st_lt.so
Description = Test DB Devel2
Host = 192.168.???.67
ServerType = SQLServer 7
FetchBufferSize = 99
UserName = sa
Password = 7board
Database = pubs
ReadOnly = no
Trace = 1
TraceFile = /tmp/iodbc.trace

[TDSxxxt]
Description = CIXXXB XXXTEST via FreeTDS
Options = CIXXXB
UserName = shaunp
ServerType = SQLServer 7
Driver = /usr/lib/libtdsodbc.so
Database = XXXBTEST
FetchBufferSize = 99
Host = 192.168.???.130
Password = melange

[XXXBTEST]
Description = CIXXXB XXXBTEST via ODBCbridge
Options = CIXXXB
UserName = shaunp
ServerType = SQLServer 7
Driver = /home/xxxstaff/ODBCbridge/lib/sql_st_lt.so
Database = XXXBTEST
FetchBufferSize = 99
Host = 192.168.???.130
Password = melange

[XXX2]
Driver = /home/xxxstaff/ODBCbridge/lib/sql_st_lt.so
Description = bleah

[OpenLink]
Driver = /home/openlink/lib/oplodbc.so.1
Description = Sample OpenLink MT DSN
Host = localhost
ServerType = Oracle 8
FetchBufferSize = 99
UserName =
Password =
Database =
ServerOptions =
ConnectOptions =
Options =
ReadOnly = no

[XXXtest]
Driver = /usr/local/iodbc/lib/oplodbc.so.1
Description = XXX test DB
Host = 192.168.23.130
ServerType = SQLServer 7
FetchBufferSize = 99
UserName = sa
Password = 7board
Database = XXXTEST
ReadOnly = no
Trace = 1
TraceFile = /tmp/iodbc.trace

[Default]
Driver = /home/xxxstaff/ODBCbridge/lib/sql_st_lt.so
Description = Test DB Devel2
Host = 192.168.???.67
ServerType = SQLServer 7
FetchBufferSize = 99
UserName = sa
Password = 7board
Database = pubs
ReadOnly = no
Trace = 1
TraceFile = /tmp/iodbc.trace

[DEFAULT]
Driver = /home/xxxstaff/ODBCbridge/lib/sql_st_lt.so
Description = Test DB Devel2
Host = 192.168.???.67
ServerType = SQLServer 7
FetchBufferSize = 99
UserName = sa
Password = 7board
Database = pubs
ReadOnly = no
Trace = 1
TraceFile = /tmp/iodbc.trace

[ODBC]
DebugFile = /tmp/odbc.debug

[ODBC Drivers]
OpenLink (MT) = Installed
TDS = Installed
PostgresSQL = Installed

[OpenLink (MT)]
Description = USD4000
Driver = /usr/lib/liboplodbcS.so.1
Setup = /usr/lib/liboplodbcS.so.1

[TDS]
Description = TDS v0.53 with protocol v7.0
Driver = /usr/lib/libtdsodbc.so
Driver = /usr/lib/libtdsodbcS.so
FileUsage = 1

[PostgresSQL]
Description = PostgresSQL
Driver = /usr/lib/libodbcpsql.so
Setup = /usr/lib/libodbcpsqlS.so
FileUsage = 1




Archive powered by MHonArc 2.6.24.

Top of Page