Skip to Content.
Sympa Menu

freetds - [freetds] FreeTDS and unixODBC issues on Mac OS X

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Vinh Nguyen <vinhdizzo AT gmail.com>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: [freetds] FreeTDS and unixODBC issues on Mac OS X
  • Date: Sat, 15 May 2010 10:54:13 -0700

Dear list,

First, let me know if I should contact unixODBC instead and sorry for
the inconvenience.

After getting the locale issue of FreeTDS resolved (thanks to you
guys, specifying v8.0 works now), I'm trying to get the two working
together on my Mac OS X, both compiled from source. tsql (I use it
through bsqldb for batch) works. However, I get the following when
issuing isql:

[S1000][unixODBC][FreeTDS][SQL Server]Unable to connect to data source
[01000][unixODBC][FreeTDS][SQL Server]Unknown host machine name.
[ISQL]ERROR: Could not SQLConnect

A TDSDUMP yields
log.c:196:Starting log file for FreeTDS 0.83.dev.20100504
on 2010-05-15 10:34:22 with debug flags 0x4fff.
iconv.c:337:tds_iconv_open(0x10010c210, ISO-8859-1)
iconv.c:197:local name for ISO-8859-1 is ISO-8859-1
iconv.c:197:local name for UTF-8 is UTF-8
iconv.c:197:local name for UCS-2LE is UCS-2LE
iconv.c:197:local name for UCS-2BE is UCS-2BE
iconv.c:365:setting up conversions for client charset "ISO-8859-1"
iconv.c:367:preparing iconv for "ISO-8859-1" <-> "UCS-2LE" conversion
iconv.c:408:preparing iconv for "ISO-8859-1" <-> "ISO-8859-1" conversion
iconv.c:411:tds_iconv_open: done
util.c:337:tdserror(0x100108540, 0x10010c210, 20013, 0)
odbc.c:2118:msgno 20013 20003
util.c:367:tdserror: client library returned TDS_INT_CANCEL(2)
util.c:390:tdserror: returning TDS_INT_CANCEL(2)
login.c:421:IP address pointer is empty
login.c:423:Server SYBASE not found!
mem.c:615:tds_free_all_results()
error.c:412:odbc_errs_add: "Unable to connect to data source"
error.c:584:SQLError(0x0, 0x10010bbf0, 0x0, 0x7fff5fbfd6a0,
0x7fff5fbfd6b4, 0x7fff5fbfdea0, 513, 0x7fff5fbfd6be)
error.c:562:_SQLError: "Unknown host machine name."
error.c:584:SQLError(0x0, 0x10010bbf0, 0x0, 0x7fff5fbfd6a0,
0x7fff5fbfd6b4, 0x7fff5fbfdea0, 513, 0x7fff5fbfd6be)
error.c:562:_SQLError: "Unable to connect to data source"
error.c:584:SQLError(0x0, 0x10010bbf0, 0x0, 0x7fff5fbfd6a0,
0x7fff5fbfd6b4, 0x7fff5fbfdea0, 513, 0x7fff5fbfd6be)
odbc.c:3883:SQLFreeConnect(0x10010bbf0)
odbc.c:3855:_SQLFreeConnect(0x10010bbf0)
odbc.c:3906:SQLFreeEnv(0x100101e40)
odbc.c:3893:_SQLFreeEnv(0x100101e40)
[S1000][unixODBC][FreeTDS][SQL Server]Unable to connect to data source
[01000][unixODBC][FreeTDS][SQL Server]Unknown host machine name.
[ISQL]ERROR: Could not SQLConnect

If i do "osql -S adrc -U name -P password", I get the following at the end:
checking shared odbc libraries linked to isql for default directories...
/usr/local/bin/osql: line 53: ldd: command not found
strings: can't open file: (No such file or directory)
osql: problem: no potential directory strings in "/usr/local/bin/isql"
osql: advice: use "osql -I DIR" where DIR unixODBC\'s install prefix
e.g. /usr/local
isql strings are:
checking odbc.ini files
reading /Users/vinh/.odbc.ini
[adrc] found in /Users/vinh/.odbc.ini
found this section:
[adrc]
Driver=/usr/local/lib/libtdsodbc.so
Description=adrc
Trace=No
##servername=adrc
Server=SERVERIP
Port=1433
TDS_Version=8.0
Database=IBADataDictionary

looking for driver for DSN [adrc] in /Users/vinh/.odbc.ini
found driver line: " Driver=/usr/local/lib/libtdsodbc.so"
driver "/usr/local/lib/libtdsodbc.so" found for [adrc] in .odbc.ini
found driver named "/usr/local/lib/libtdsodbc.so"
/usr/local/lib/libtdsodbc.so is an executable file
"Server=SERVERIP" found, not using freetds.conf
Server=SERVERIP is ""
osql: no value found for "Server=SERVERIP" entry in .odbc.ini


Why is the IP string empty?

Thanks.
Vinh




Archive powered by MHonArc 2.6.24.

Top of Page