Skip to Content.
Sympa Menu

freetds - [freetds] RE: FreeTDS Digest, Vol 22, Issue 19

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Alf C Stockton <alf AT stockton.co.za>
  • To: "Lowden, James K" <LowdenJK AT bernstein.com>
  • Cc: unixodbc-dev AT unixodbc.org, freetds AT lists.ibiblio.org
  • Subject: [freetds] RE: FreeTDS Digest, Vol 22, Issue 19
  • Date: Sat, 13 Nov 2004 14:51:31 +0000 (UTC)

On Fri, 12 Nov 2004, Lowden, James K wrote:


Show us the result using isql, and the odbc.ini and freetds.conf (if
any) entries. That should make pretty clear what's going on.

root@puppypad:/usr/local/src/freetds-0.62.3# isql k9pad
[ISQL]ERROR: Could not SQLConnect
root@puppypad:/usr/local/src/freetds-0.62.3# isql doghouse
[ISQL]ERROR: Could not SQLConnect
root@puppypad:/usr/local/src/freetds-0.62.3# isql K9Pad
[ISQL]ERROR: Could not SQLConnect
root@puppypad:/usr/local/src/freetds-0.62.3# isql DogHouse
[ISQL]ERROR: Could not SQLConnect

Thank you for your explanation.
Attached please find the odbc.ini and freetds.conf and above is the result of isql calls the two servers I am trying to get to. K9Pad is XP SP2 & DogHouse is Win2k.

---

Regards,
Alf Stockton www.stockton.co.za

Broad-mindedness, n.:
The result of flattening high-mindedness out.[ODBC Data Sources]

[K9Pad]
Driver = /usr/local/lib/libtdsodbc.so
Description = Sybase JDBC Server
Trace = No
Servername = K9Pad
Database = jack2
UID = sa

[DogHouse]
Driver = FreeTDS
Description = Sybase JDBC Server
Trace = No
Servername = DogHouse
Database = jack2
UID = sa

[devitserver]
Driver = FreeTDS
Description = Sybase JDBC Server
Trace = No
Servername = devitserver
Database = jack2
UID = sa

#
#
# $Id: freetds.conf,v 1.9 2003/12/04 22:26:55 freddy77 Exp $
#
# 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) otherwise, if env variable FREETDSCONF specifies a properly
# formatted config file, use it,
#
# 3) otherwise, look in ~/.freetds.conf,
#
# 4) otherwise, look in @sysconfdir@/freetds.conf
#
# If FreeTDS has found no suitable conf file it will then search for
# 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.
#
# Note that environment variables TDSVER, TDSDUMP, TDSPORT, TDSQUERY,
# and TDSHOST will override values set by a .conf or .interfaces file.
#
# To review the processing of the above, set env variable TDSDUMPCONFIG
# to a file name to log configuration processing.
#
# Global settings, any value here may be overridden by a database
# server specific section
[global]
# TDS protocol version
tds version = 4.2

; initial block size = 512

# uses some fixes required for some bugged MSSQL 7.0 server that
# return invalid data to big endian clients
# NOTE TDS version 7.0 or 8.0 should be used instead
; 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.
# OBSOLETE
; 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
# OBSOLETE use DOMAIN\username as username
; nt domain = WORKGROUP

# If the server responds with different domain try that one?
# OBSOLETE never been used
; 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

# If you get out of memory errors, it may mean that your client
# is trying to allocate a huge buffer for a TEXT field.
# (Microsoft servers sometimes pretend TEXT columns are
# 4 GB wide!) If you have this problem, try setting
# 'text size' to a more reasonable limit
text size = 64512

# 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

# The same server, using TDS 4.2. Used in configuration examples for the
# pool server, since the pool server supports only TDS 4.2.
[JDBC_42]
host = 192.138.151.39
port = 4444
tds version = 4.2

# The client connecting to the pool server will use this to find its
# listening socket. This entry assumes that the client is on the same
# system as the pool server.
[mypool]
host = 127.0.0.1
port = 5000
tds version = 4.2

# A typical Microsoft SQL Server 7.0 configuration
[K9Pad]
host = 192.168.1.2
port = 1433
tds version = 7.0

# A typical Microsoft SQL Server 2000 configuration
[DogHouse]
host = 192.168.1.3
port = 1433
tds version = 8.0

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




Archive powered by MHonArc 2.6.24.

Top of Page